1) { $previousPage = $page - 1; }else { $previousPage = 1; } //------------------------------------------------// //------------------------------------------------// $citeria_pricetype = $_POST['pricetype']; $citeria_category = $_POST['category']; $citeria_city = $_POST['city']; $citeria_state = $_POST['stname']; $citeria_price = $_POST['price']; $citeria_pricehigh = $_POST['pricehigh']; $citeria_bedrooms = $_POST['bedrooms']; $citeria_bedroomshigh = $_POST['bedroomshigh']; //------------------------------------------------// if (!empty($_POST['city'])) { $CITYVAR = " and city LIKE '%%".$_POST['city']."%%' "; } if (!empty($_POST['state'])) { $STATEVAR = " and state = '".$citeria_state."' "; } if (!empty($_POST['price'])) { $PRICEVAR = " and price >= '".$_POST['price']."' "; } if (!empty($_POST['pricehigh'])) { $PRICEHIGHVAR = " and price <= '".$_POST['pricehigh']."' "; } if (!empty($_POST['bedrooms'])) { $MINBEDVAR = " and bedrooms >= '".$_POST['bedrooms']."' "; } if(!empty($_POST['bedroomshigh'])) { $MAXBEDVAR = "and bedrooms <= '".$_POST['bedroomshigh']."'"; } if (!empty($_POST['pricetype'])) { $PRICETYPEVAR = " and pricetype LIKE '".$_POST['pricetype']."' "; } ////////////pagination////////////////////////////////////// $queryPaginate = "SELECT * FROM info WHERE category LIKE '%".$_POST['category']."%' $CITYVAR $STATEVAR $PRICEVAR $PRICEHIGHVAR $MINBEDVAR $MAXBEDVAR $PRICETYPEVAR"; $arrPaginate = multiListings($queryPaginate); $resultPaginate = mysql_query($queryPaginate); $num_results = mysql_num_rows($resultPaginate); $num_results1 = $num_results; $limit = $SITElistingsamnt; $limit1 = $SITEfeaturedamnt; $numPages = ceil($num_results / $limit); $offset = ($page - 1) * $limit; //$smarty->assign('num_results', $num_results); /////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////// $querySearch = "SELECT * FROM info WHERE category LIKE '%".$_POST['category']."%' $CITYVAR $STATEVAR $PRICEVAR $PRICEHIGHVAR $MINBEDVAR $MAXBEDVAR $PRICETYPEVAR ORDER BY `pk` DESC limit $offset, $limit"; $resultListings = mysql_query($querySearch); $num_results=mysql_num_rows($resultListings); while ($myrowListings = mysql_fetch_assoc($resultListings)) { $Ldateentered = $myrowListings["dateentered"]; $Lname = $myrowListings["name"]; $Laddress = $myrowListings["address"]; $Lcity = $myrowListings["city"]; $Lstate = $myrowListings["state"]; $Lzip = $myrowListings["zip"]; $Ltelephone = $myrowListings["telephone"]; $Lfax = $myrowListings["fax"]; $Lwebsite = $myrowListings["website"]; $Lemail = $myrowListings["email"]; $Ldescription = $myrowListings["description"]; $Lbedrooms = $myrowListings["bedrooms"]; $Lbedroomshigh = $myrowListings["bedroomshigh"]; $Lsqfeet = $myrowListings["sqfeet"]; $Lprice = $myrowListings["price"]; } ////////build search results listings//////////////////// ?>
 

Browse Results ( listings found for )



0"; } else { $Sbedrooms_style = $Sbedrooms; } ?> 0"; } else { $Sbathrooms_style = $Sbathrooms; } ?> 0"; } else { $Scarparks_style = $Scarparks; } ?>
Bedrooms:
Property ID:
Property Name:
City/State: /
Price:
<? $myrowSearch['name'] ?>
View Property

© 2007 Queensland Exclusive Properties Pty Ltd. All Rights Reserved.