= 40000 AND annual_rent <= 100000 AND "; }elseif($fldprice_to ==2){ $searchquery .= " annual_rent >= 100000 AND annual_rent <= 150000 AND "; }elseif($fldprice_to ==3){ $searchquery .= " annual_rent >= 150000 AND annual_rent <= 200000 AND "; }else{ //$searchquery .= " annual_rent >= 200000 AND "; $searchquery .= " annual_rent <= $fldprice_to AND "; //rahas } } if($fldpropcity !="") { $searchquery .= " city = '$fldpropcity' AND"; } $searchquery .= " is_active = 'Y' AND is_pending = 'N' AND is_rejected = 'N' ORDER BY modified_on DESC"; } else if(isset($_REQUEST["allhot"])) { $searchquery = "SELECT * FROM property_master WHERE is_active = 'Y' AND is_hot = 'Y' AND is_pending = 'N' AND is_rejected = 'N' ORDER BY modified_on DESC"; } else if(isset($_REQUEST["allbyagent"])) { $fldagentid = $_REQUEST["allbyagent"]; $searchquery = "SELECT * FROM property_master WHERE is_pending = 'N' AND is_active = 'Y' AND is_hot = 'N' AND is_rejected = 'N' AND prop_agent_id = $fldagentid ORDER BY modified_on DESC"; } else if(isset($_POST["btnTopRightSearch_x"])) // Top Right search { $fldsearchterm = trim($_POST["txtkeyterm"]); $searchquery = "SELECT * FROM property_master WHERE prop_name like '%$fldsearchterm%' OR prop_facilities like '%$fldsearchterm%' OR prop_desc like '%$fldsearchterm%' AND is_active = 'Y' AND is_pending = 'N' AND is_rejected = 'N' AND 1 = 1"; } else if(isset($_POST["btnAdvSearch_x"])) // Advance Search { $searchquery = "SELECT * FROM property_master WHERE prop_for_id = '$fldpropertyfor' AND type_ref_id = '$fldprop_type' AND location_ref_id = '$fldlocation' AND development_ref_id = '$flddevelopment' AND no_beds = '$fldselbedrooms' AND prop_price >= '$fldprice_from' AND prop_price <= '$fldprice_to' AND is_active = 'Y' AND is_pending = 'N' AND is_rejected = 'N' AND 1 = 1"; } else if(isset($_POST["btnBuySearch_x"])) // Search Buy prop page { $searchquery = "SELECT * FROM property_master WHERE prop_for_id = 'buy' AND type_ref_id = '$fldprop_type' AND "; if($fldlocation != "") { $searchquery .= " location_ref_id = '$fldlocation' AND"; } $searchquery .= "development_ref_id = '$flddevelopment' AND no_beds = '$fldselbedrooms' AND"; if($fldprice_from != "") { $searchquery .= " prop_price <= '$fldprice_from' AND"; } if($fldprice_to != "") { $searchquery .= " prop_price <= '$fldprice_to' AND"; } $searchquery .= " is_active = 'Y' AND is_pending = 'N' AND is_rejected = 'N' AND 1 = 1"; } else if(isset($_POST["btnRentSearch_x"])) // Search Rent prop page { $searchquery = "SELECT * FROM property_master WHERE prop_for_id = 'rent' AND type_ref_id = '$fldprop_type' AND "; if($fldlocation != "") { $searchquery .= " location_ref_id = '$fldlocation' AND"; } $searchquery .= " development_ref_id = '$flddevelopment' AND no_beds = '$fldselbedrooms' AND "; if($fldprice_from != "") { $searchquery .= " prop_price <= '$fldprice_from' AND"; } if($fldprice_to != "") { $searchquery .= " prop_price <= '$fldprice_to' AND"; } $searchquery .= " is_active = 'Y' AND is_pending = 'N' AND is_rejected = 'N' AND 1 = 1"; } else if($flddevelopment != "") // Search Rent prop page { $searchquery = "SELECT * FROM property_master WHERE development_ref_id = '$flddevelopment' AND is_active = 'Y' AND is_pending = 'N' AND is_rejected = 'N' AND 1 = 1 ORDER BY modified_on DESC"; } else { //echo "BINGO!!!!!!!!"; $searchquery = "SELECT * FROM property_master WHERE is_active = 'Y' AND is_pending = 'N' AND is_rejected = 'N' AND 1 = 1 ORDER BY modified_on DESC "; } //echo "Testing....".$searchquery; $searchresult = mysql_query($searchquery) or die($searchquery.mysql_error()); $searchtot = mysql_num_rows($searchresult); // Paging code $querycount = $searchtot; include_once("include/universal_paging.php"); if($querycount > 0) { //$searchquery = $searchquery." LIMIT $offset,$pages->items_per_page"; $searchquery = $searchquery." LIMIT $offset,20"; } $searchresult = mysql_query($searchquery) or die($searchquery.mysql_error()); $searchtot = mysql_num_rows($searchresult); ?>
|
PROPERTY SEARCH RESULT
|
||||||||||||||||||||||||||||||||||||||||||||||