stmosaic Posted October 30, 2006 Share Posted October 30, 2006 I have what should be a simple GROUP BY and ORDER BY that is only returning 1 item from each category rather than all of the records grouped together. [code]results=mysql_query("select * FROM db_name GROUP BY category ORDER BY ordernum LIMIT $rowstart,10");[/code]The results I want to get are: category1 blah, blah category1 blah, blah category1 blah, blah category2 blah, blah category2 blah, blah category3 blah, blah category3 blah, blah category3 blah, blahRight now, the number of rows per category ranges from 2 to 12 entries. Yet only one per category shows up. No error codes. I'm not sure why it won't work. I've looked through the forum & the tutorials, but most of them are more complex queries than what I'm doing. Can anyone see what I might be doing wrong? Link to comment https://forums.phpfreaks.com/topic/25537-simple-group-byorder-by-not-working/ Share on other sites More sharing options...
toplay Posted October 30, 2006 Share Posted October 30, 2006 It's doing what you told it to by grouping categories. You don't want to use "GROUP BY" at all in this case, and just use "ORDER BY category, ordernum". Link to comment https://forums.phpfreaks.com/topic/25537-simple-group-byorder-by-not-working/#findComment-116540 Share on other sites More sharing options...
stmosaic Posted October 30, 2006 Author Share Posted October 30, 2006 toplay, THANK YOU!!! That's the solution. My SQL background is VERY weak (and it shows!) Link to comment https://forums.phpfreaks.com/topic/25537-simple-group-byorder-by-not-working/#findComment-116542 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.