Jump to content

Archived

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

stmosaic

Simple Group By/Order By not working

Recommended Posts

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, blah

Right 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?

Share this post


Link to post
Share on other sites
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".

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.