need to get results only from form input where ALL the entries exist in the database. How do I syntax so that all the searchterms entered in the submitted form must be present to show database results?
Here is the code i have thus far. Thanks.
$query_string = "SELECT apn, recording_date, status, street_number, property_type, gross_building_area, number_of_units, sale_price_per_gross_sf
FROM $tablename
WHERE (apn LIKE '%".$searchterm1."%' AND ( recording_date >= '%".$searchterm2."%' AND recording_date <= '%".$searchterm3."%') AND ( land_area_gross_sf >= '%".$searchterm7."%' AND land_area_gross_sf <= '%".$searchterm8."%') )
";
