I'm starting a new project for a company I work for not sure if they will end up using it or not. I am not a programmer but am working on learning it. I have been asked to make a php/sql schedule for the rink to display all the events for the day. So far I have my database set up with the following columns: date, event, event_title, start_time, end_time, team_one, team_one_lr, team_two, team_two_lr. All of the datatypes are set at varchar since I am not to familiar with all the other types.
The problem I am trying to solve atm is when adding events to the schedule how do I check to make sure the times do not conflict? Its not a huge issue but I would like a warning to pop up if someone try's to add a event that conflicts with something already in the DB.
Another issue I am trying to solve is when displaying the events for the day I want the event's that have all ready taken place to no longer be displayed. Ex. If a game ends at 10:00 at 10:10 I want the event to be taken off. I think I know how to get the page to refresh every time minutes using this
header("Refresh: 600; url='\\condition\\index.php'");