Re: [PHP-DB] Multiple Sorts

[kc68]

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 <[EMAIL PROTECTED]> 
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

RE: [PHP-DB] Multiple Sorts

[Hutchins, Richard]

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-
> From: Robert Sossomon [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 16, 2004 7:57 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Multiple Sorts
> 
> 
> 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
> 
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Multiple Sorts??

[Petr Tomenendál]

> $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 * FROM pfiles WHERE cdate >= '2002-07-01'
ORDER BY 'cdate' DESC, 'vendor' DESC", $link);

Petr.



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php