Robert,
You should be able to just do:
SELECT * FROM access_tracking WHERE user = '$user_id' ORDER BY time
DESC,date_accessed ASC;
Just experiment with the ORDER BY columns and the ASC and DESC orders to get
the results you're looking for.
Hope this helps,
Rich
-Original Message-
I asked this question several weeks ago; search for kc68 on this list
archives and you should find the more complete response. The coding with
my fields is:
?sort_field=cbc asc, net_receiptssort_order=desc Play with the order and
asc and desc as another response suggested. What's confusing
$result = mysql_query(SELECT * FROM pfiles WHERE cdate = '2002-07-01'
ORDER BY 'cdate' DESC, $link);
I would like to be able to sort this data FIRST by 'cdate' then by 'vendor'
Is this possible?
Yes.
Just add another sort criterium to your query like this:
$result = mysql_query(SELECT *