Jump to content

Archived

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

chico1st

second sort?

Recommended Posts

okay i need to sort articles by date first then within date by author name... is there a command for this or does it get complicated?
any help will be great
THANKS!

Share this post


Link to post
Share on other sites
ORDER BY date, author_name?

Share this post


Link to post
Share on other sites
Okay i just went to implement this and i realized that they are in different tables.
The only solution i can think of is to read one month's worth of articles into an array.
sort that array by author name then move on to the next month
this would work but it seems very cumbersome
Any ideas?
THANKS!

Share this post


Link to post
Share on other sites
Different tables? Well, if you JOIN them, you can use whatever columns from either table to ORDER (though you may incur a filesort).

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.