How to get all rates between given dates?
Can you help me to show me a sample query for the below information.
I have a table with below info.
id, hotel, startdate, enddate, accomrate, transferrate, mealplanrate.
I need get rates for every induvidual date, transfer rate for start date, and transfer rate for end date, mealplan for eachday. also I have three four type of meal plans and three type of transfer. I want get these information from mysql and display it on screen according to user selected range.
I will be very thankful if you can give me a sample query for this.