Howdy. this is in relation to the last few posts I have made, but I wanted to keep them seperate.

I have a "updates" page for one of my clients. I have recently put all the updates in a DB and would like to display the 5 most recent on the main page with a generated link to read the older ones in descending chronological order with 5 results per page.

What would be the best way to do this? The fields in the DB are

id (I made sure to enter the oldest ones first)
date (in yyyy-mm-d format)