check availability & rates script?
I'm building websites for 2 private charter yachts, both travel between the Caribbean and Europe and are available on the charter market.
Basically, they have varying rates for between 2 and 10 guests, summer and winter rates, periods of not being available, etc. What I would like to do is allow a potential customer to select a desired date range to charter the boat, select number of guests and region. The results can either be 'available' for this amount, or 'not available', allowing the customer to perfrom another search.
This information can easily be put into a table, but here are my questions:
1. How do I format the table(s), i.e dates and date ranges,
2. Do I use Access or MySQL? (I have both),
3. How do I get started?
You can tell I'm new at this, so any help is appreciated.