Display most recent?

[mscreashuns]

Okay, for my site I am going to have updates on the main page and it's going to be set up sort of like a blog (without comments) where I add entries to the database and then it displays them on the index page. They each have an id that auto increments. How do I only display the most recent entry? I am guessing I would use the id, but how?

[MikeSnead]

The query that pulls the data should be set up something like:

SELECT id_number, field_1, field_2 FROM table_name ORDER BY id_number DESC

Ideally you should have a field in that table that records the timestamp the record was created and then order by that field. If you you have a field that records the date, order by that instead of the ID.

[mscreashuns]

Okay, thanks. I'll try that. 😉

[tunage]

You should also use LIMIT so it just returns 1 row, rather than every entry -

SELECT id_number, field_1, field_2 FROM table_name ORDER BY id_number DESC LIMIT 0,1