Hi, I am designing a hotel website in PHP and MySQL. I am having a problem with getting the room rate on a specified date. Can someone please help me with the query and output in PHP, this would be greatly appreciated. My tables are below.
Basically, when someone searches using arrival and departure dates, I would like the result page to show the hotel name, the room names, the hotel season name, and the rates for the dates in between arrival and departure, in order to show a quote
QUICK NOTE, I have not used PEAR before, if this is where the solution lies, please include short explanation.
Thanks in anticipation !
hotel_table
hotel_id (PK)
hotel_name
room_table
room_id (PK)
hotel_id (FK)
room_name
room_rate_table
room_rate_id (PK)
hotel_season_id (FK)
room_rate_name
room_rate_amount
hotel_season_table
hotel_season_id (PK)
hotel_id (FK)
hotel_season_name
hotel_season_start_date
hotel_season_end_date
query and output (date calculation)
Moderator: General Moderators