thank you... this worked. best, addison

Simple MySQL.

After your ORDER BY clause use either ASC (I think this is the default) or
DESC. I'm pretty sure this'll work on date fields to produce the results you
want.

Your query will end up looking like:
"...order by createdate DESC"

 -----Original Message-----
 From: Addison Ellis [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, February 04, 2003 5:28 AM
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] date: reverse order


 hello,
	when retrieving data from the db and displaying it on the
 page by creation date how can i reverse the order so that the most
 recent entry appears first? here's what i have now:

 <?
 require("config.php");

          $obj = mysql_db_query($dbname,"select * from ads
 order by createdate");
 ?>


 thank you addison
 --
 Addison Ellis
 small independent publishing co.
 114 B 29th Avenue North
 Nashville, TN 37203
 (615) 321-1791
 [EMAIL PROTECTED]
 [EMAIL PROTECTED]
 subsidiaries of small independent publishing co.
 [EMAIL PROTECTED]
 [EMAIL PROTECTED]

 --
 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
--
Addison Ellis
small independent publishing co.
114 B 29th Avenue North
Nashville, TN 37203
(615) 321-1791
[EMAIL PROTECTED]
[EMAIL PROTECTED]
subsidiaries of small independent publishing co.
[EMAIL PROTECTED]
[EMAIL PROTECTED]

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

Reply via email to