Re: hotel reservation system.

On Wednesday 27 September 2006 15:16, Faisal Sahar wrote: > hi to everyone, > > i want to create a hotel reservation system. how can i keep track of > dates . suppose i have booked a room from 12/10/2006 till 14/10/2006 ( two > night ) how can i make a system that will check for room availability and > if it will find a room available from specified date till specified date > it will report me back. > > i wish to find a suitable and technical answer .. > > faisal very tough and long question... If I wrote that kind of system.. 1-) I want to know rooms 2-) I want to knwo room occupation dates... System have to mark roop occupation day basis... for example... room_occupation_table roomId, occupationDate, customerId room_table roomId,roomName,roomType get occupied rooms select roomId from room_occupation_table where occupationDate >11/10/2006 and occupationDate < 15/10/2006 get rooms selec roomId,roomName from room_table extract occupied rooms from rooms then show the unoccupied rooms at that time. Then mark yoru newly occupied rooms... Regards Sancar.