----- Original Message -----
From: Andrius Jakutis <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 12, 2001 12:12 PM
Subject: [PHP-DB] order by question


> Ok, here is the question:
>
> I write to order by date "Order by date".
>
> So, it output's something like this:
>
> 2001 08 01
> 2001 08 02
> 2001 08 03
>
> What if I want to order by date, but not from the older to newest, but
from
> newest to older ?
>
> The same is with numbers - priority
>
> I use order by priority.
>
> It lists: 1
> 2
> 3
> 4
>
> But how to list like this:
> 4
> 3
> 2
> 1
>
>
> Thanks

Use "ORDER BY Date ASC" or "ORDER BY Date DESC" for ascending and
descending.

regards
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
Tel: +852-2573-5033
Fax: +852-2573-5851






-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to