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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php