\n\tAll States\n\t"; $q1 = "select distinct state from yellow_agents 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\tAll Cities\n\t"; $q1 = "select distinct city from yellow_agents 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\tAll Countries\n\t"; $q1 = "select distinct country from yellow_agents 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"; $SelectStr = ptypes(0); //create the PropertyType menu $TypeMenu = str_replace("\n\t\n\t", "\n\tAny Type\n\t", $SelectStr); //agents menu $q1 = "select AgentID, FirstName, LastName from yellow_agents order by FirstName, LastName"; $r1 = mysql_query($q1) or die(mysql_error()); $AgentsMenu = "\n\tAny Agent\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])) { } ?>