'0') { $s = $CatInfo[1]; } } if(!empty($_POST[search_country])) { $search_country = $_POST[search_country]; } if(!empty($_POST[search_state])) { $state = $_POST[search_state]; } if(!empty($_POST[search_city])) { $search_city = $_POST[search_city]; } if(!empty($_POST[search_PropertyType])) { $search_PropertyType = $_POST[search_PropertyType]; } if(!empty($_POST[MinPrice])) { $min = $_POST[MinPrice]; } if(!empty($_POST[MaxPrice])) { $max = $_POST[MaxPrice]; } if(!empty($_POST[MinRooms])) { $rooms1 = $_POST[MinRooms]; } if(!empty($_POST[MaxRooms])) { $rooms2 = $_POST[MaxRooms]; } if(!empty($_POST[MinBath])) { $bath1 = $_POST[MinBath]; } if(!empty($_POST[MaxBath])) { $bath2 = $_POST[MaxBath]; } if(!empty($_POST[AgentID])) { $agent = $_POST[AgentID]; } if(!empty($_POST[old])) { $before = $_POST[old]; } if(!empty($_POST[NearSchool])) { $school = $_POST[NearSchool]; } if(!empty($_POST[NearTransit])) { $transit = $_POST[NearTransit]; } if(!empty($_POST[NearPark])) { $park = $_POST[NearPark]; } if(!empty($_POST[OceanView])) { $ocean_view = $_POST[OceanView]; } if(!empty($_POST[LakeView])) { $lake_view = $_POST[LakeView]; } if(!empty($_POST[MountainView])) { $mountain_view = $_POST[MountainView]; } if(!empty($_POST[OceanWaterfront])) { $ocean_waterfront = $_POST[OceanWaterfront]; } if(!empty($_POST[LakeWaterfront])) { $lake_waterfront = $_POST[LakeWaterfront]; } if(!empty($_POST[RiverWaterfront])) { $river_waterfront = $_POST[RiverWaterfront]; } $url = "search.php?c=$c&s=$s&search_country=$_POST[search_country]&search_state=$_POST[search_state]&search_city=$_POST[search_city]&search_PropertyType=$_POST[search_PropertyType]&MinPrice=$min&MaxPrice=$max&rooms1=$rooms1&rooms2=$rooms2&bath1=$bath1&bath2=$bath2&AgentID=$agent&before=$before&school=$school&transit=$transit&park=$park&ocean_view=$ocean_view&lake_view=$lake_view&mountain_view=$mountain_view&ocean_waterfront=$ocean_waterfront&lake_waterfront=$lake_waterfront&river_waterfront=$river_waterfront"; header("location:$url"); exit(); } require_once("includes.php"); /* //create the category menu $CategoryMenu = "\n\t\n\t"; $q1 = "select * from re2_categories order by CategoryName"; $r1 = mysql_query($q1) or die(mysql_error()); if(mysql_num_rows($r1) > '0') { while($a1 = mysql_fetch_array($r1)) { $CategoryMenu .= "$a1[CategoryName]\n\t"; //get the subcategories $q2 = "select * from re2_subcategories where CategoryID = '$a1[CategoryID]' order by SubcategoryName "; $r2 = mysql_query($q2) or die(mysql_error()); while($a2 = mysql_fetch_array($r2)) { $CategoryMenu .= "$a1[CategoryName] - $a2[SubcategoryName]\n\t"; } } } $CategoryMenu .= "\n"; */ //create the state menu $StateMenu = "\n\tAlle provincies\n\t"; $q1 = "select distinct state from re2_listings order by state"; $r1 = mysql_query($q1) or die(mysql_error()); if(mysql_num_rows($r1) > '0') { while($a1 = mysql_fetch_array($r1)) { $StateMenu .= "$a1[state]\n\t"; } } $StateMenu .= "\n"; //create the city menu $CityMenu = "\n\tAlle plaatsen\n\t"; $q1 = "select distinct city from re2_listings order by city"; $r1 = mysql_query($q1) or die(mysql_error()); if(mysql_num_rows($r1) > '0') { while($a1 = mysql_fetch_array($r1)) { $CityMenu .= "$a1[city]\n\t"; } } $CityMenu .= "\n"; //create the country menu $CountryMenu = "\n\tAlle Landen\n\t"; $q1 = "select distinct country from re2_listings order by country"; $r1 = mysql_query($q1) or die(mysql_error()); if(mysql_num_rows($r1) > '0') { while($a1 = mysql_fetch_array($r1)) { $CountryMenu .= "$a1[country]\n\t"; } } $CountryMenu .= "\n"; //create the PropertyType menu $TypeMenu = "\n\tAlle woningen\n\t"; $q1 = "select distinct PropertyType from re2_listings order by PropertyType"; $r1 = mysql_query($q1) or die(mysql_error()); if(mysql_num_rows($r1) > '0') { while($a1 = mysql_fetch_array($r1)) { $TypeMenu .= "$a1[PropertyType]\n\t"; } } $TypeMenu .= "\n"; //create the Price Minimum menu $MinPrice = "\n\tMinimaal\n\t"; $q1 = "select distinct Price from re2_listings order by Price asc"; $r1 = mysql_query($q1) or die(mysql_error()); if(mysql_num_rows($r1) > '0') { while($a1 = mysql_fetch_array($r1)) { $prices .= "€ $a1[Price]\n\t"; } } $MinPrice .= $prices."\n"; //create the max price menu $MaxPrice = "\n\tMaximaal\n\t"; $MaxPrice .= $prices."\n"; //bedrooms $MinBed = "\n\tMinimaal\n\t"; for($i = '1'; $i <= '20'; $i++) { $bed .= "$i\n\t"; } $MinBed .= $bed."\n"; $MaxBed = "\n\tMaximaal\n\t"; $MaxBed .= $bed."\n"; //bathrooms $MinBath = "\n\tMinimaal\n\t"; for($i = '1'; $i <= '10'; $i++) { $bath .= "$i\n\t"; } $MinBath .= $bath."\n"; $MaxBath = "\n\tMaximaal\n\t"; $MaxBath .= $bath."\n"; //agents menu $q1 = "select AgentID, FirstName, LastName from re2_agents order by FirstName, LastName"; $r1 = mysql_query($q1) or die(mysql_error()); $AgentsMenu = "\n\tAlle aanbieders\n\t"; if(mysql_num_rows($r1) > '0') { while($a1 = mysql_fetch_array($r1)) { $AgentsMenu .= "$a1[FirstName] $a1[LastName]\n\t"; } } $AgentsMenu .= "\n"; require_once("templates/HeaderTemplate.php"); require_once("templates/AdvancedSearchTemplate.php"); if(!ereg("index.php", $_SERVER[SCRIPT_NAME])) { require_once("templates/FooterTemplate.php"); } ?>