How can I able to sort a MySQL table by two columns?
What I need are the articles sorted by the highest ratings first, then the most recent date. As an example, this would be a sample output (left # is the rating, then the article title, then the article date)
50 | This article rocks | Feb 4, 2009
35 | This article is pretty good | Feb 1, 2009
5 | This Article isn't so hot | Jan 25, 2009
The relevant SQL I'm using is:
ORDER BY article_rating, article_time DESC
I can be able to sort it by one or the other, but not the both.