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
> 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
4 matches
Mail list logo
