leeming Posted August 28, 2006 Share Posted August 28, 2006 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= 0team2=1team3=1team4=2[/quote]So am i looking for a HAVING addition to my query? Quote Link to comment Share on other sites More sharing options...
fenway Posted August 28, 2006 Share Posted August 28, 2006 I don't understand.. you have an order by/limit... I'm confused. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.