Help with PHP MySQL stuff.?

  • Thread starter Thread starter imported_ufo_josh
  • Start date Start date
I

imported_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.
 
Back
Top