> 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"); > ?> You rely on the list to much for simple questions. SELECT * FROM ads ORDER BY createdate DESC ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php