I'm not completely sure how to implement this so I'd like to ask you to give me an idea if you can
For a tennis booking system.. it will look something similar to (should be a table but this is for the sake of the idea)
Date: Oct 25th, 2010 (go to oct 26)
Court 1 Court 2 Court 3 Court 4
8:00 Open(bookit) Tally Open Hellio
9:00 Andy Roger Barney Training
...etc
Now everyday, this table should be empty, so new bookings can be made
how would I make it so a new table is empty /or has dif bookings every day (based on date) efficiently?
Im guessing I will have dif values in the sql table for dif dates but what I'm not sure of is how to display it in page
for ex, if someone presses the button oct 26, the new table is for that date, wif diff values