Create a stastics page in php/mysql

I have a table booking site for restaurants. I need a page that describes the booking situation for the same day years back in time. (Example. Today March 14th 2008 the restaurant has reservations for 1408 people in the future. Now I want to know how many reservations I had in the future the same day 1 year ago, 2 years ago.) This can't be calculated on load. So I want one page that is run daily that checks the booking situation the previous day and the years before and diaplsys the results on a new page that looks like this: Restaurant: x ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 2006? ? ? ? ? ? ? ? ? ? 2007? ? ? ? ? ? ? ? 2008 ----------------------------------------------------- March 12? ? ? ? ? 1212? ? ? ? ? ? ? ? ? 1602? ? ? ? ? ? ? ? ? ? 1900 March 13? ? ? ? ? ? 1185? ? ? ? ? ? ? ? ? 1630? ? ? ? ? ? ? ? ? ? 1925 All reservations are in a table with these columns: REST (restaurant_id) AMOUNT? (number of people in the reservation) DINNER_START? (date and time in unix timestamp format) STATUS? (if reservation is valid) REG_DATE? (date mode when reservation was taken) ## Deliverables I have attached a screen dump of the table structure. You will see that there are other fields in the table, but they are not needed for this project. I have also attached data from the table, so if anyone wants to create the page and test, go ahead.