U
ufo_josh
Guest
I have a booking calendar database with the following fields:
booking_id (foreign Key linking to Bookings table)
calendar_startdate
calendar_enddate
calendar_status
So the booking obviously takes up all the dates between the startdate and enddate and there can only be one booking on each date.
I then have a form for users to make a booking request with the fields "start date" and "end date" this checks the database to see if the date range entered (between startdate and enddate) is available or not.
But I am not too sure how to do it. Any help or suggestions would be great.
booking_id (foreign Key linking to Bookings table)
calendar_startdate
calendar_enddate
calendar_status
So the booking obviously takes up all the dates between the startdate and enddate and there can only be one booking on each date.
I then have a form for users to make a booking request with the fields "start date" and "end date" this checks the database to see if the date range entered (between startdate and enddate) is available or not.
But I am not too sure how to do it. Any help or suggestions would be great.