room availability not functioning...someone please give guidance..
View Single Post
03-24-2010, 09:35 AM
Join Date: Mar 2010
thanks for delayedinsanity for the reply...
i finally manage to get the query that produce the result that i wanted:
here it is .
SELECT rt.roomtype, rt.roomprice
FROM roomtype rt
INNER JOIN rooms r ON rt.roomtypeID = r.roomtypeID
WHERE r.roomID NOT
WHERE checkin >= '2010-04-01'
AND checkout <= '2010-04-06'
GROUP BY rt.roomtypeID
however, i did really appreciate your helps.
thanks again. Cheers! :D
View Public Profile
Send a private message to fairytale89
Find More Posts by fairytale89