I'm writing a PHP file that will take variables from the POST method (I know how to do this) and insert them into a table at the top. Then it will push the other 10 rows down one, and delete the last one.
So basically it's a table with rows of the most recent 10 updates. Here it is:
Thanks for the help!
I would suggest adding a timestamp column to your table that gets set to the current time when a row is added.
Then you could query the table and order the results by the new column to get what your after.
If you have to limit the number of rows in the table for some reason, you could delete rows 11-n programmatically.
I have a feeling that's not what you're looking for, but here's some quick pseudo-code anyways...
You could also order the result by comment_id descending to get the same effect.
answered Apr 21 '11 at 05:33 AM