Select Query

zed420 · #1 (**permalink**) 08-26-09, 18:04

Hi All
Its online calendar(in php) for a driving instructor where by clicking on a day it gives you that day's diary it has time slots from 08:00 to 20:00, all fine till if someone books more than an hr long lesson.
This query below works and avoids all the Overlaping BUT only for the first booking and thereafter it overlaps. Why??? Any thoughts please ???
Zed

Code:

SELECT COUNT(*) AS Cnt   
     FROM booking   
     WHERE request_date='$request_date'   
     AND e_time > '$s_time'   
     AND s_time < '$e_time'

r937 · #2 (**permalink**) 08-26-09, 20:05

saw this before on the other forum, and you have the same problem here -- not enough information

please dump the table layout and a few rows of representative sample data

Internet Services

Web Development

Digital Marketing

Consumer Tech