If their are a total of 10 rooms, and 5 rooms have been booked between certain dates.
A customer then enters an arrival date and a depature date into a web form (done).
The sql should then search the database and state that there are 5,6,7 or whatever rooms available to book between the dates they entered.
So an example table layout:
BID DATEARR DATEDEP ROOM
1 5-dec-2005 7-dec-2005 5
2 6-dec-2005 7-dec-2005 9
3 5-dec-2005 9-dec-2005 7
4 4-dec-2005 14-dec-2005 10
5 3-dec-2005 5-dec-2005 3
So a user will select an arrival date and a departure date and how many rooms they wish to book. Then the system checks for available rooms to book.
20 freelancers are bidding on average $67 for this job
Dear Sir, We have already created this kind of booking system for one of our client. We are just waiting for your go ahead... Kindly visit us at [url removed, login to view] Thanks!!
I would like some more info about your project. Is this production level? or is it a Proof of Concept type of web application? Contact me via PMB regarding your project.
Hello, We have done lots of work in PHP/MySql and can do a very good job for you. We will definately provide you a classic solution which will be the most benifical for you. Thanks & Regards, Saurabh
Hello Sir, Our team has strong experience in web site designing and development. We have biuld many [url removed, login to view] you feel us relable then we can work with you. Thank You. Regards , RS Infotech.