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? Link to comment https://forums.phpfreaks.com/topic/18862-group-by-question/ 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. Link to comment https://forums.phpfreaks.com/topic/18862-group-by-question/#findComment-81886 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.