An error occurred while trying to connect to the MySQL server. MySQL returned the following error information: " .mysql_error(). " (error #" .mysql_errno(). ")"));
// Retrieves the database.
$db_get = mysql_select_db($db_name, $db_link)
or die(reportScriptError("
Unable to locate the database. Please double check
config.php to make sure the
\$db_name variable is set correctly."));
// Return the connection
return $db_link;
}
// end
function safe( $value ) {
$pattern = array(
"/\\r/i",
"/\\n/i",
"/\%0a/i",
"/\%0d/i",
"/bcc:/i",
"/to:/i",
"/cc:/i"
);
return preg_replace($pattern, "", $value );
}
function getAffiliateSQL($affilliateID) {
$filename = "http://www.jeffcobusinessnetwork.org/includes/affiliateSQL.inc";
$handle = fopen($filename, "r");
$fr = fread($handle, 1024);
fclose($handle);
$sql = ereg_replace('~AffilliateID~', $affilliateID, $fr);
return ($sql);
}
$sql = getAffiliateSQL($myAffilliateID);
$db_link = openDatabase($db_hostname, $db_username, $db_password, $db_name);
$affiliates = mysql_query($sql, $db_link)
or die(reportScriptError("Unable to retrieve affiliate data."));
while ($affiliate = mysql_fetch_array($affiliates)) {
$affiliateNm = stripslashes($affiliate['firstname'])." ".stripslashes($affiliate['lastname']);
$affiliateBusNm = stripslashes($affiliate['BusName']);
$affiliatePhone = stripslashes($affiliate['phone1']);
$affiliateTitle = stripslashes($affiliate['Title']);
if ($affiliate['webpageURL']) {
$affiliateWebLink = "
"
.stripslashes($affiliate['webpageName'])."";
} else {
$affiliateWebLink = "";
}
?>
'; } ?>
•
,
Phone:
Website:
'; } ?>