Yes. I flipped thru the manpages and found:
expr BETWEEN min AND max
If expr is greater than or equal to min and expr is less than or equal to max,
BETWEEN returns 1, otherwise it returns 0. This is equivalent to the expression (min
<= expr AND expr <= max) if all the arguments are of the sam
> Great! Thanks Murray.
Hi Roger,
On second thoughts, perhaps the BETWEEN operator isn't what you're looking
for, since it will probably return false matches on bordering reservations.
In other words, someone attempting to make a reservation between 10am and
12pm might be told there's a conflict
Great! Thanks Murray.
--
roger
Quoting "Murray @ PlanetThoughtful" <[EMAIL PROTECTED]>:
>
> > How will a PHP script perform such checking to prevent that sort of
> > overlapping in reservation ? Or could it be that my database design is bad
> > that's blocking ideas into my head ?
>
> Hi Roge
I would like to do some sort of facilities reservation system. Suppose this is for
booking , say, a meeting room.
Booking detail to be stored in db:
- name or id of person
- meeting room number
- date and time (when room will be used)
- number of hours to be allocated
Now say Peter booked room R
> How will a PHP script perform such checking to prevent that sort of
> overlapping in reservation ? Or could it be that my database design is bad
> that's blocking ideas into my head ?
Hi Roger,
I think you need to check out the BETWEEN operator in MySQL (assuming you're
using MySQL? Look for t
5 matches
Mail list logo
