Jump to content

Archived

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

leeming

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

[quote]
team1= 0
team2=1
team3=1
team4=2
[/quote]

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.