0 ) { $agentInfo = mysql_fetch_array($result); $subdir = strtolower($agentInfo['firstName'].$agentInfo['lastName']); //header("Location: agent.php?agentID=".$agentInfo['agentID']); header("Location: http://www.century21today.com/agentIDX/".$subdir); } include("includes/dbConnection.php"); if( $_REQUEST['agentID'] != "" ) { $agentInfo = mysql_fetch_array(mysql_query("SELECT * FROM agents WHERE agentID = ".$_REQUEST['agentID'])); // check the MLS agent ID cookie for lead generation to make sure it exists if( !isset($_COOKIES['agentMLSID']) ) setcookie("agentMLSID", $agentInfo['mlsnAgentID'], time()+60*60*24*180 , "/"); } // get the school districts for the search dropdown $school_districts = array(); $schoolDistrictTables[0] = 'idxResidential'; $schoolDistrictTables[0] = 'idxCondo'; $schoolDistrictTables[0] = 'idxCommercial'; $schoolDistrictTables[0] = 'idxMultiFamily'; $schoolDistrictTables[0] = 'idxVacantLand'; foreach ($schoolDistrictTables as $qTableName) { $schoolDistrictsQuery = "SELECT DISTINCT School_District FROM ".$qTableName." WHERE School_District <> '' ORDER BY School_District"; $sd_result = mysql_query($schoolDistrictsQuery); while( $schoolDistrict = mysql_fetch_array($sd_result)) { $school_districts[] = $schoolDistrict['School_District']; } } ?>
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||