Check Available Rooms For Selected Dates

I won't understand how did you booked rooms.
There are should be reservation start date and end date data to do such queries.

Hi neuron.

Do you mean the structure of reservation table ?

Are not "days column" enough for that operation which keeps records after having received selected days via a for loop upon a date selection both for date_in and date_out?