[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-db
Subject:    Re: [PHP-DB] ORDER BY
From:       Chris <dmagick () gmail ! com>
Date:       2006-10-19 0:09:25
Message-ID: 4536C235.9080808 () gmail ! com
[Download RAW message or body]

Ron Piggott (PHP) wrote:
> Is it possible to do an ORDER BY column_a column_b ASC  ?  IE Can you
> specify two columns to cause the output to be displayed in a specific
> order?  Ron
> 

Yes (a quick search would have told you this too).

It's best to specify the order for each one:

order by column_a asc, column_b asc;

or

order by column_a asc, column_b desc;

for example.

-- 
Postgresql & php tutorials
http://www.designmagick.com/

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

[prev in list] [next in list] [prev in thread] [next in thread]