Simple Room Booking Facility is project number 36305
posted at Freelancer.com. Click here to post your own project.
Status: Cancelled
Selected Providers: -
Budget: $30-100
Created: 12/15/2005 at 16:06 EST
Bid Count: 20
Average Bid:
$ 67
12/16/2005 at 16:06 EST
Project Creator:
activeware
Employer Rating: (No Feedback Yet)
|
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. |
|
Job Type |
|