|
|
Posted by Pankaj on 10/26/06 12:55
between would fetch me all records in the given range. It would not
distinguish if the value of the field is 0 or 1 (available or booked)
> I don't s'pose this is really a php issue, it'll depend on what database
> you're using. Presumably whatever that is it'll give you a way to effect
> "between", because you want to find any existing bookings *between* the
> start and the end date that your prospect is trying to book.
>
> It may be doable in a single query. It might depend on your table
> structure of course.
>
> Something like :- (serving suggestion)
>
> SELECT * FROM Bookings WHERE BETWEEN(BookingDate, NewStart, NewFinish)
> AND Room=theRoom;
>
>
> Regards
> Mark
Navigation:
[Reply to this message]
|