Hello everybody.

I am currently developing a simple judge scheduling application for a mulit-school competition in business. There will be a number of judges registering to judge events. I have created two tables for registering. 1. jegreg with EventID and JudgeID 2. EventID, EventTitle, Day, StartTime, StopTime. I combined them together in a MySQL VIEW so that when a judge enters the event ID, the event info is combined with their ID into one place. I need the feature of checking for a date/time conflict for each judge. For example:

Judge A registers for an event on Thursday 9:00 - to 11:00
Judge A also tries to register for another event on Thursday 10:30 - 12:30

How do I build a script and/or function that would warn the user they have a time conflict?

Thank you in advance.

aavgeek