last 3 database entries

[jkh1978]

With a php site connected to a mysql database, what is the best way to chose the last 3 entries made?

Also, is there a way to sort the results and get like the 5th one?

[freddydoesphp]

Assuming you have a timestamp field in your table, you can do this to get the last three entries.

SELECT * from tablename ORDER BY timestamp DESC LIMIT 3;

To get the fifth one

SELECT * from tablename ORDER BY timestamp DESC LIMIT 4,1;