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? Quote Link to comment 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". Quote Link to comment 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!) 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.