![]() |
Searching room availability between arrival and depature date..PHP - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5) +--- Forum: Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=11) +--- Thread: Searching room availability between arrival and depature date..PHP (/showthread.php?tid=74801) |
Searching room availability between arrival and depature date..PHP - phyu - 11-07-2019 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 |