Multiple Sorts
| From: | Robert Sossomon | Date: | Tue, 16 Mar 2004 12:57:25 +0000 |
| Subject: | Multiple Sorts | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-33463@lists.php.net to get a copy of this message | ||
How can I write a sort to sort on 2 columns, one ascending, one
descending?
$get_list = "select * from access_tracking where user = '$user_id' order
by time,date_accessed desc"
But the ordering seems backwards sorted by date first, and then time.
TIA!!
Robert