Hello , I am doing a project on Resort Website where I have a module of Room Reservation. I want a code for checking the availability of rooms when user selects arrival date and departure date and clicks check button.
database
room_details table
------------------
roomno
type
rate_regular
rate_delux
rate_suite
--------------------
room table
----------
roomno
custid
check_in_date
check_out_date
no_of_room
no_of_members
room_type
room_status