sorting on two different fields?
My duBois book is at home so I figured I'd ask here to see if anyone has a quick answer. Is there a way to sort on two different fields AND arrange them differently with DESC,ASC?
For example... take this query (please)
SELECT * FROM table WHERE category='$id' ORDER BY field1,field2 DESC
That's great except that I want field1 sorted with DESC and then field2 sorted with ASC. This does not work:
SELECT * FROM table WHERE category='$id' ORDER BY field1,field2 DESC,ASC
Is there any way to do this without reading the results into an array and re-sorting it yourself?