Re: date: reverse order
| From: | 1LT John W. Holmes | Date: | Tue, 04 Feb 2003 12:26:51 +0000 |
| Subject: | Re: date: reverse order | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25404@lists.php.net to get a copy of this message | ||
> 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...