im writting a Motel programming used for bookings rooms
the Client books a room for a number of days, the program checks to see if that room is free on the particular date chosen .
eg 29/7/02 and staying for 3 nights
i need to add the 3 nights to the date ( 29/7/02 ) and check if that room will be available for those nights
*How will i code the SQL Query statement ??????
*How will i add 3 nights to the date 29/7/02