Show ten newest entries.

neilmasters

Table:
id - int, auto increment
author - text, not null
submission - longtext, not null
date - 0000-00-00(default)

What I would like to do is create a script which will display the newest ten entries, I thought of doing it this way:

Run a loop to count the table size and then display each entry Total-1, Total-2, Total-3 etc etc, however I am unsure In my mind if this is suitable or if it would even work.

If you have any ideas, peices of code that has been successful for others, explanations etc etc I would be very grateful.

laserlight

Which database management system are you using? One way would be to sort by the date in descending order, and then take the first 10 rows in the result set, e.g.,

SELECT * FROM tablename ORDER BY date DESC LIMIT 10

neilmasters

I was going to post "Oh there is another solution which would be... [insert your suggestion above]" but refreshed to check :/

As for the database, this is the tricky thing, it can be flat file or sql. Currently I have it running off sql.

But that solves it for the moment, ta for your input.

laserlight

neilmasters wrote:
As for the database, this is the tricky thing, it can be flat file or sql. Currently I have it running off sql.

Try and substitute the flat file database with an SQLite database instead. That way you can use a database abstraction library if you need to instead of writing one yourself, or you can write a more lightweight database wrapper yourself instead of having to implement a flat file database.