chico1st Posted August 10, 2006 Share Posted August 10, 2006 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 greatTHANKS! Quote Link to comment Share on other sites More sharing options...
fenway Posted August 10, 2006 Share Posted August 10, 2006 ORDER BY date, author_name? Quote Link to comment Share on other sites More sharing options...
chico1st Posted August 10, 2006 Author Share Posted August 10, 2006 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 monththis would work but it seems very cumbersomeAny ideas?THANKS! Quote Link to comment Share on other sites More sharing options...
fenway Posted August 10, 2006 Share Posted August 10, 2006 Different tables? Well, if you JOIN them, you can use whatever columns from either table to ORDER (though you may incur a filesort). 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.