I need a simple PHP/MySQL system. (Better if it was a function to return a simple true/positive if the dates selected are available. Eg.
The user will enter 2 dates eg. 12 February 2008 and 17 February 2008, the script will check the MySQL database to see if the property is available between those dates and 0 for no.
There are 2 property's, so the script should return the id of the property that is available eg. 1 or 2
So php should be something like:
// Check to see if any property is available bewteen $startdate and enddata
$result = $propertyid
$result = 0
I hope i've made it clear enough...