I need a php5/mysql5 search on up to 5 tables as part of a villa availability search on a holiday rental website. The tables and availability/price calendar are already in place, as is the form and an availability script. I require a script that returns the results based on users criteria and optional available days from the calendar and within the optional user price budget.
The page format is already complete for the resultset to go into.
Here is a brief on what happens; the site user uses a search form to select certain criteria they require for their holiday property, i.e. area, property type, number of person property sleeps, private pool, pets allowed etc. The form also has an optional section for date of arrival and departure and the maximum price the user wants to pay for the duration.
If the user adds the optional dates and price, the search also looks through the calendar and only return properties that meet the criteria, are available and within the price and where the property advertiser has elected to display their calendar.
Properties can have the pricing structure entered in per week or per night and also in GBP, EUR and USD so that would need to be factored into the search.
As I said, I already have the form, the tables and a query that searches the calendar, I just need a combined script that does all of the above.
Apache version 2.2.8 (Unix)
PHP version 5.2.5
MySQL version 5.0.51a-community