CodeIgniter Forums

Full Version: Searching room availability between arrival and depature date..PHP
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi guys...I am now working  the online reservation system for hotel for final year project and i am beginner in php.All the data transcation are done and
 I am stuck at checking room availability between date
My tables are following like this 

Roomtype-------
RoomtypeID
Name
Price
------
Reservation----
ReservationID
RoomtypeID
Arrival date
DepartureDate
------
I want to know how to make the SQL query