SMTP server errors and a too-quick click made me close the message I
sent with all the nifty thread-ness... sorry.
//make reservation
insert into reservation(room_number, start_date, end_date)
values ('504', '12/10/2006', '14/10/2006')
//reservation inquiry for 13/10/2006:
select room_number
from room
where room_number not in
(select room_number
from reservation
where '13/10/2006' between start_date and end_date
)
The rest of the application is left as an exercise to the reader. :-)
--
Like Music?
http://l-i-e.com/artists.htm
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
