[Birdie501]

[QUOTE]Originally posted by FireFly
Try changing this:

$allstyles=$DB_site->query("SELECT style.title, user.styleid, COUNT(*) AS count FROM user LEFT JOIN style USING (styleid) WHERE style.styleid IS NOT NULL AND style.userselect=1 GROUP BY user.styleid");

to this:

$allstyles=$DB_site->query("SELECT style.title, user.styleid, COUNT(*) AS count FROM style LEFT JOIN user USING (styleid) WHERE style.userselect=1 GROUP BY user.styleid");