Re: Multiple Sorts
| From: | kc68 at cornell dot edu | Date: | Tue, 16 Mar 2004 13:35:48 +0000 |
| Subject: | Re: Multiple Sorts | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-33465@lists.php.net to get a copy of this 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_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@gcnorris.com> 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