Fw: [PHP] Checking for Overlapping Dates

Thomas (and list), The solution, as previously posted, is flawed/incomplete - mea culpa. Excuse: I was interrupted three times from typing the word SELECT until pressing Send, and then rushing to get on to the next call on my time... >WHERE bstart < afinish > OR bfinish > astart; Check

Re: [PHP] Checking for Overlapping Dates

Hi Thomas, > SELECT * from $DB_TBLName WHERE > (Trim(WorkerEmail)='$userReplacementEmail') > AND AND OR OR OR OR OR This is all a bit complicated, and a simple boy like me gets lost too easily. KISS principle: Keep it simple... You have two employees: A, so named because he Already has Annu

[PHP] Checking for Overlapping Dates

Hi, Background: I've created a vacation-request application for our company's intranet. When an employee requests a vacation, he has to list the name of another employee who will 'fill in' for him while he is gone. Before a vacation request can be saved in MySQL, I need to