Last db items?

[Kyle123]

How can I select the last 5 db items? I was thinking a timestamp or some thing.

[AyKay47]

You mean the last 5 rows?

A combination of ORDER BY and LIMIT would most likely be the solution, however we would need to see the db table setup.

[Psycho]

What he said. But, you will need a field to use for ordering the records to achieve this. If there is an auto-incrementing ID field you can use that. Otherwise you would probably want to create a timestamp field that is automatically populated when the record is created. If you have an existing field of either type you can use that. If not, you can add either one such that you wouldn't have to change any of your existing code since they would be handled automatically by the database.

 

The query to get what you need would look something like this

SELECT field1, field2, field3
FROM table_name
ORDER BY order_field DESC
LIMIT 5

 

Where 'order_field' is the auto-incrementing int or timestamp field.

[Pikachu2000]

As long as you have the timestamp field as a UNIX timestamp, or a valid YYYY-MM-DD HH:MM:SS format:

 

ORDER BY timestamp_field DESC LIMIT 5