BooWho Posted October 26, 2006 Share Posted October 26, 2006 I have a series of drop-down menus which make up an advanced search form. I am having major problems understanding how to make the results page work though - I tried researching and testing stuff but no joy whatsoever. The search form code is straightforward enough:[code]<form action="multiresults.php" method="post" name="frmSearch" target="_self" id="frmSearch"><p>District<br /><select name="district" id="district" style="width:160px;"><option value="" selected="selected">All districts</option><option value="Nicosia">Nicosia</option><option value="Limassol">Limassol</option><option value="Larnaca">Larnaca</option><option value="Paphos">Paphos</option><option value="Famagusta">Famagusta</option></select></p><p>Type<br /><select name="type" id="type" style="width:160px;"><option value="" selected>All types</option><option value="house">House</option><option value="apartment">Apartment</option><option value="plot">Plot</option><option value="land">Land</option><option value="bungalow">Bungalows</option><option value="detached">Detached</option><option value="semi">Semi-detached</option><option value="villa">Villa</option><option value="terraced">Terraced</option><option value="penthouse">Penthouse</option><option value="duplex">Duplex</option><option value="maisonette">Maisonette</option><option value="groundfloor">Ground floor apartment</option><option value="agricultural">Agricultural</option><option value="commercial">Commercial</option><option value="industrial">Industrial</option><option value="mixedzone">Mixed zone</option><option value="residential">Residential</option></select></p><p>Bedrooms<br /><select name="beds" id="beds" style="width:160px;"><option value="" selected>Any beds</option><option value="1">0</option><option value="2">1</option><option value="3">2</option><option value="4">3</option><option value="5">4</option><option value="6">5</option><option value="7">6+</option><option value="8">studio</option></select></p><p>Price from<br /><select name="price1" id="price1" style="width:160px;"><option value="" selected>Any price</option><option value="10000">10,000</option><option value="20000">20,000</option><option value="30000">30,000</option><option value="40000">40,000</option><option value="50000">50,000</option><option value="60000">60,000</option><option value="70000">70,000</option><option value="80000">80,000</option><option value="90000">90,000</option><option value="100000">100,000</option><option value="150000">150,000</option><option value="200000">200,000</option><option value="250000">250,000</option><option value="300000">300,000</option><option value="350000">350,000</option><option value="400000">400,000</option><option value="450000">450,000</option><option value="500000">500,000</option><option value="550000">550,000</option><option value="600000">600,000</option><option value="700000">700,000</option><option value="800000">800,000</option><option value="900000">900,000</option><option value="1000000">1,000,000</option></select></p><p>Price to<br /><select name="price2" id="price2" style="width:160px;"><option value="" selected>Any price</option><option value="10000">10,000</option><option value="20000">20,000</option><option value="30000">30,000</option><option value="40000">40,000</option><option value="50000">50,000</option><option value="60000">60,000</option><option value="70000">70,000</option><option value="80000">80,000</option><option value="90000">90,000</option><option value="100000">100,000</option><option value="150000">150,000</option><option value="200000">200,000</option><option value="250000">250,000</option><option value="300000">300,000</option><option value="350000">350,000</option><option value="400000">400,000</option><option value="450000">450,000</option><option value="500000">500,000</option><option value="550000">550,000</option><option value="600000">600,000</option><option value="700000">700,000</option><option value="800000">800,000</option><option value="900000">900,000</option><option value="1000000">1,000,000</option><option value="1000000+">1,000,000+</option></select></p><p><input name="submit" type="image" id="submit" src="images/search.jpg" width="64" height="21" border="0" alt="Search" title="Search" /></p></form>[/code]The results page code, well, let's just say that is pretty much useless! But here is the code anyway:[code]<?php$maxRows_rcsResult = 15;$pageNum_rcsResult = 0;if (isset($_GET['pageNum_rcsResult'])) { $pageNum_rcsResult = $_GET['pageNum_rcsResult'];}$startRow_rcsResult = $pageNum_rcsResult * $maxRows_rcsResult;$colname_rcsResult = "1";if (isset($_REQUEST['district'])) { $colname_rcsResult = (get_magic_quotes_gpc()) ? $_REQUEST['district'] : addslashes($_REQUEST['district']);}$colname_rcsResult2 = "1";if (isset($_REQUEST['type'])) { $colname2_rcsResult = (get_magic_quotes_gpc()) ? $_REQUEST['type'] : addslashes($_REQUEST['type']);}mysql_select_db($database_connW, $connW);$query_rcsResult = sprintf("SELECT * FROM realestate WHERE district = '%s' AND type = '%s'", $colname_rcsResult,$colname_rcsResult2);$query_limit_rcsResult = sprintf("%s LIMIT %d, %d", $query_rcsResult, $startRow_rcsResult, $maxRows_rcsResult);$rcsResult = mysql_query($query_limit_rcsResult, $connW) or die(mysql_error());$row_rcsResult = mysql_fetch_assoc($rcsResult);if (isset($_GET['totalRows_rcsResult'])) { $totalRows_rcsResult = $_GET['totalRows_rcsResult'];} else { $all_rcsResult = mysql_query($query_rcsResult); $totalRows_rcsResult = mysql_num_rows($all_rcsResult);}$totalPages_rcsResult = ceil($totalRows_rcsResult/$maxRows_rcsResult)-1;$queryString_rcsResult = "";if (!empty($_SERVER['QUERY_STRING'])) { $params = explode("&", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_rcsResult") == false && stristr($param, "totalRows_rcsResult") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_rcsResult = "&" . htmlentities(implode("&", $newParams)); }}$queryString_rcsResult = sprintf("&totalRows_rcsResult=%d%s", $totalRows_rcsResult, $queryString_rcsResult);?>[/code]Perhaps someone knows of a good tutorial I can refer to? I would appreciate any help. Quote Link to comment Share on other sites More sharing options...
BooWho Posted October 26, 2006 Author Share Posted October 26, 2006 Can anyone help with this search/results problem? Thanks. Quote Link to comment Share on other sites More sharing options...
BooWho Posted October 27, 2006 Author Share Posted October 27, 2006 Has anyone got any experience with advanced searches like this? It's new to me, but I'm sure there must be someone out there with the skills to help me - I have a simple form, with dropdowns, which queries one table and then displays any results. At the moment I am having no luck at all getting this to work, so I would really appreciate some help - it's the last thing left to do on the site now, and it's holding back completion. Thanks. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.