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
