\n\t\n\t"; //$q1 = "select distinct state from yellow_agents order by state"; $q1 = "select state from usstates order by state"; $r1 = mysql_query($q1) or die(mysql_error()); if(mysql_num_rows($r1) > '0') { while($a1 = mysql_fetch_array($r1)) { $StateMenu .= "\n\t"; } } mysql_free_result($r1); $StateMenu .= "\n"; //--------------------- // create the city menu //--------------------- $CityMenu = "\n"; mysql_free_result($r1); //------------------------- // create the Zip Code menu //------------------------- $ZipCodeMenu = "\n"; mysql_free_result($r1); //------------------------- // create the Region menu //------------------------- $RegionMenu = "\n"; mysql_free_result($r1); //---------------------------------------- // create the Business Classification menu //---------------------------------------- // $SelectStr2 = ctypes(0); $ClassifMenu = str_replace("\n\t\n\t", $SelectStr2); //----------------------------- // create the PropertyType menu //----------------------------- $SelectStr = ptypes(0); $TypeMenu = str_replace("\n\t\n\t", $SelectStr); //------------------------ // create the country menu //------------------------ $CountryMenu = "\n"; mysql_free_result($r1); ////------------ //// agents menu ////------------ // //$q1 = "select AgentID, FirstName, LastName from yellow_agents order by FirstName, LastName"; //$r1 = mysql_query($q1) or die(mysql_error()); // //$AgentsMenu = "\n"; //mysql_free_result($r1); $aset[SiteTitle] = "New York Yellow Pages, Business 411 - Find Anything"; $aset[SiteDescription] = "The New York Yellow Pages, Business 411, Find Anything in NewYork."; require_once("templates/usHeaderTemplate.php"); require_once("templates/usAdvancedSearchTemplate.php"); //if(!ereg("usadvanced-search.php", $_SERVER[SCRIPT_NAME])) //{ require_once("templates/usFooterTemplate.php"); //} require_once("close.php"); ?>