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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php