Okay, I'm pretty new at PHP but I think I see at least where the soloution is.
In the index.php file if I changed 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 user LEFT JOIN style USING (styleid) style.userselect=1 GROUP BY user.styleid");
Would that correct the problem of the list only showing styles that a user is actually on?
|