Jump to content


This topic is now archived and is closed to further replies.


group by, question..

Recommended Posts

im wanting to run a query where the group by returns values in these groups (eg) 1/2/3/4.. even if the value is 0....

kinda hard to explain if you dont understand the above..
this is my code...
[code]SELECT count( side ) AS cntTeam, side FROM `users` WHERE game = '$game' GROUP BY side ORDER BY cntTeam ASC LIMIT 1[/code]

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

team1= 0

So am i looking for a HAVING addition to my query?

Share this post

Link to post
Share on other sites
I don't understand.. you have an order by/limit... I'm confused.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.