I am developing an appointment book and running into several problems. I would appreciate any help.
This is an overview of my appointment book. After user clicks on a date on monthly view calendar, user will see a schedule list that has several columns & rows. Each column is occupied by an employee. Each row is 15 min increment of time. User can click on available cells of that schedule list to make an appointment
These are problems that i am running into:
1. I can't figure out how to COLOR the table cells of the schedule list that have been booked.
- I also have problem with checking for conflict appointments (range checking)
Here is appointment database table structure:
appointment
appointment_id
appointment_start_time
appointment_duration
employee_id (foreign key)
thank you
