Ok so im looking to create a simple booking system as part of my Final Year Project. I have a locally hosted mySQL database created and linked to using php. I have created a databse called reservations with 3 tablels (Available, reserves and confirms). Basically what I am looking to achieve is that a user can reserve a room from a list of say 6, and confirm the reservation with payment (just for asthetics, will not be functional) but if they dont confirm within a set amount of time the reservation is cancelled and that room is once again available to any other user looking to make a booking. Any help would be appreciated.