?sort_field=cbc asc, net_receipts&sort_order=desc Play with the order and asc and desc as another response suggested. What's confusing is that the first field requires only the asc statement where the second requires the full &sort_order=
Ken
********
On Tue, 16 Mar 2004 07:57:25 -0500, Robert Sossomon <robert@xxxxxxxxxxxx> wrote:
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
