I have a database listing timeslots for particular days, consisting of
I output these to a html table to display, for example,
Time Status Slot ID
09:00 Available 1
09:10 Available 2
09:20 Available 3
09:30 Busy 4
09:40 Available 5
Some of my appointment times may be more than the 10 minute slot interval so I need to ability to check if the next time slot is available, so for example, I need to make an appointment for 20 minutes at 09:00 and both SlotID 1 and 2 are available so I can book it and make it busy. However, If I try to book a 20 minute appointment at 09:20 an alert box should appear as only the 1st 10 minutes are available.
Is this possible? May be asking too much can anyone assist?