ORDER BY multiple items

[VooDooRT]

Is it possible to ORDER BY multiple variables? I want to order by date on a query then, once that's ordered, I want to order by another variable.

[JDcrack]

This is absolutely possible:

For instance if you had a table with the columns name and age,
if you wanted to display the results first by name in alphebetical order, then by descending age, your SQL query would look something like this:

SELECT * FROM table_name WHERE name != '1' ORDER BY name ASC, age DESC

http://www.mysql.com/doc/en/ORDER_BY_optimisation.html

[VooDooRT]

Outstanding, thank you!!!!