PHP help wanted
I'm having some problems with PHP. I'm writing a calender website and the problem I'm having is with the appointment making page. What I want it to do is query a database of appointments using a given date, if there's no appointment at that time I want it to echo the time as an option in a list, but if there is an appointment then I don't want the time to be listed as an option. So basically I want the option list to list only times when there isn't an appointment.
Another option is to have the calender so that I just click on the date to get the day view and then the time to create the appointment, but that'd also require a database query to find out when there isn't an appointment.
I can get it to display appointment details just fine, but finding out when there isn't an appointment is what I'm having problems with.
If anyone has any suggestions that might help, and maybe some sample code that I could use, that'd be great.
Edit: I'm using a MySQL database to store the appointment information.
Another option is to have the calender so that I just click on the date to get the day view and then the time to create the appointment, but that'd also require a database query to find out when there isn't an appointment.
I can get it to display appointment details just fine, but finding out when there isn't an appointment is what I'm having problems with.
If anyone has any suggestions that might help, and maybe some sample code that I could use, that'd be great.
Edit: I'm using a MySQL database to store the appointment information.