Re: newest entry in db
| From: | Jed Verity | Date: | Sat, 31 Aug 2002 17:17:04 +0000 |
| Subject: | Re: newest entry in db | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21495@lists.php.net to get a copy of this message | ||
There might be a better way, but you can always do:
Select * from table order by timestampfield desc limit 1
HTH,
Jed
On the threshold of genius, Victor wrote:
> How can I use php to get the newest entry from mysql database? Ie, if I
> make a timestamp and then I want to retrieve the last timestamp I made
> how do I go about doing it? Any php or mysql documentation?
>
> - Victor > www.argilent.com
>
>
> ______________________________________________________________________
> Post your ad for free now! http://personals.yahoo.ca