Can someone help me out here? I am doing on-line reservations for a Guesthouse.
These are my tables:
Customer Room Reservation
Rates
In Reservation I have the fields
Arrival_Date
Dept_date both of type DATE
What I am trying to do is query the database (I'm using mySQL) to check availability. The 1st interface for the customer consists of a menu for room type (i.e. twin, double etc.) and also menus for arrival and departure dates(3 menus for each..day, month,year of arrival AND then also dept) and I am trying to check availability in the db from these parameters on the interface and I need help on my SQL query as I've tried it lots of different ways and I can't get it!
Any help here would be greatly appreciated..I think I'm stumped!
These are my tables:
Customer Room Reservation
Rates
In Reservation I have the fields
Arrival_Date
Dept_date both of type DATE
What I am trying to do is query the database (I'm using mySQL) to check availability. The 1st interface for the customer consists of a menu for room type (i.e. twin, double etc.) and also menus for arrival and departure dates(3 menus for each..day, month,year of arrival AND then also dept) and I am trying to check availability in the db from these parameters on the interface and I need help on my SQL query as I've tried it lots of different ways and I can't get it!
Any help here would be greatly appreciated..I think I'm stumped!