kinda hard to explain if you dont understand the above..
this is my code...
SELECT count( side ) AS cntTeam, side FROM `users` WHERE game = '$game' GROUP BY side ORDER BY cntTeam ASC LIMIT 1
basicly when new users play, they are put on the side with the least number of players... but the group by doesnt return 0 values (???)...
im wanting it to return results some thing like
So am i looking for a HAVING addition to my query?