I am developing a property site where visitors can search for property. I have 5 dropdowns in the search script, eg as below:
STATE (dropdown)
All
New York
Los Angeles
Ohio
CITY (dropdown)
All
(the remaining list of cities here will be determined by the state selected above)
Type (dropdown)
Sales
Buy
MIN PRICE (dropdown)
All
$500
$2,000
$10,000
$500,000
MAX PRICE (dropdown)
All
$500
$2,000
$10,000
$500,000
If the visitor selected all in all the 4 fields (exept type field), I search my table as below;
$search="select * from property where type='$type'";
$query=mysql_query($search)
The above worked fine, but how will i put teh script when some are 'ALL' and some are not 'ALL'
I tried the below but it didn't word
Code: Select all
if($state=='All') {$state2="";} else {$state2="state='$state' ";}
if(($state=="All") && ($city != "All")) {$city2= "city = '$city' ";}
elseif(($state!="All") && ($city != "All")) {$city2= "and city = '$city' ";}
else $city2="";
if(($state=="All") && (city == "All")) {$type2 .= "type = '$type' ";}
else {$type2= "and type = '$type' ";}
if($property=='All') $property2=""; else $property2="and property = '$property' ";
if($min_price=='All') $min_price2=""; else $min_price2="and min_price => '$min_price' ";
if($max_price=='All') $max_price2=""; else $max_price2="and max_price <= '$max_price' ";
$where = $state2."".$city2."".$type2."".$property2."".$min_price."".$max_price;
$select="select * from property where $where order by property_id desc";
$query = mysql_query($sql_select);
Code: Select all
$type2 = "type='$type' and ";
if($state=='All') {$state2==""; $city2=="";}
elseif($state!='All' && $city=="All") $state2=" state='$state' and";
else $state2=" state='$state' and city='$city' and ";
if($property=='All') $property2=="";
elseif($property=='All' && $min_price!='All') $property2=="property='$property' and ";
else $property2="property='$property'";
if($min_price=='All') $min_price2=="";
elseif($min_price=='All' && $max_price!="All") $min_price2=="min_price='$min_price' and ";
else $min_price2="min_price='$min_price'";
if($max_price=='All') $max_price2=="";
elseif($max_price=='All' && $bedroom!='any') $max_price2=="max_price='$max_price' and ";
else $max_price2="max_price='$max_price'";
if($bedroom=='any') $bedroom2=="";
elseif($bedroom!='any') $bedroom2=="bedroom='$bedroom' and ";
else $bedroom2="bedroom='$bedroom'";
if($bathroom=='any') $bathroom2=="";
else $bathroom2=" and bathroom='$bathroom'";
$where = "where ";
$where .= $state2;
$where .= $city2;
$where .= $min_price2;
$where .= $type2;
$where .= $property2;
$where .= $max_price2;
$where .= $bedroom;
$where .= $bathroom;
$sql_select="select * from property $where order by property_id desc LIMIT $from,$max_results";
$query = mysql_query($sql_select);