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
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
2 matches
Mail list logo