Hi guys,
I have a query that pulls member photos. Default Y, not Default N. The problem is when the user has not set a default and they are all N… its pulling all the N photos for that user instead of just one. Somehow I’ve broken the query and I’m not sure how.
$result568=mysql_query("SELECT DISTINCT
u.name, u.age, u.category, u.info1, u.info12, u.lastlogin, u.lastactivity
,COALESCE(u2i.url,u2i2.url) url
FROM
usertable u
LEFT OUTER
JOIN
imagetable u2i
ON
u.name = u2i.name
AND
u2i.default = 'Y'
LEFT OUTER
JOIN
imagetable u2i2
ON
u.name = u2i2.name
WHERE
(u2i.priv != 1 && u2i.status = 'active' OR u2i2.priv !=1 && u2i2.status = 'active') && u.name IN (" . $picar . ") ORDER BY field(u.name, $picar) LIMIT 30;");