Re: order by question

----- Original Message ----- From: Andrius Jakutis <andrius@internetmedia.lt> To: <php-db@lists.php.net> 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