Dealing with Time
Posted: Fri Nov 07, 2003 12:16 pm
Can anyone point me to some tutorials on managing time with PHP/MySQL.
Specifically I am building a meeting room scheduling application for my office and I am having difficulty how to manage the time issue. Things like checking to make sure a room is open when scheduling it for a meeting. So if someone schedules a room from 12 to 1 then someone else attempts to schedule the room at 12:30, how do I have PHP check and see that time falls within the range of a time that the room is already in use?
It is a MySQL back end so would I be able to use SQL command to check this?
Any help would be greatly appreciated.
Specifically I am building a meeting room scheduling application for my office and I am having difficulty how to manage the time issue. Things like checking to make sure a room is open when scheduling it for a meeting. So if someone schedules a room from 12 to 1 then someone else attempts to schedule the room at 12:30, how do I have PHP check and see that time falls within the range of a time that the room is already in use?
It is a MySQL back end so would I be able to use SQL command to check this?
Any help would be greatly appreciated.