SELECT * FROM mytable ORDER BY timestampcolumn DESC LIMIT 1
or
SELECT * FROM mytable ORDER BY id DESC LIMIT 1
HTH
Justin French
on 01/09/02 2:25 AM, Victor ([EMAIL PROTECTED]) 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php