$dnum = date(Ymd)*4;
$from = $_GET['fr'];
if($from == ""){
$from = $_POST['fr'];
}
if($from != $dnum){
echo("<<<<Restricted Area>>>>" .
"
Sorry, you must Log In to view this Page
");
exit();
}
$usrn = $_GET['usrn'];
if($usrn == ""){
$usrn = $_POST['usrn'];
}
if($usrn == ""){
echo("<<<<Restricted Area>>>>" .
"
Problem with your username. Please Log In again.
");
exit();
}
$first_Name = $_POST['first_Name'];
$Name = $_POST['Name'];
$Title = $_POST['Title'];
$Company = $_POST['Company'];
$biztype = $_POST['biztype'];
$Phone = $_POST['Phone'];
$Address = $_POST['Address'];
$FAX = $_POST['FAX'];
$City = $_POST['City'];
$email = $_POST['email'];
$mkt = $_POST['mkt'];
$State = $_POST['State'];
$ZipCode = $_POST['ZipCode'];
$alt_con = $_POST['alt_con'];
$alt_title = $_POST['alt_title'];
$alt_email = $_POST['alt_email'];
$act_month = $_POST['act_month'];
$act_day = $_POST['act_day'];
$act_year = $_POST['act_year'];
$contact_type = $_POST['contact_type'];
$act_respond = $_POST['act_respond'];
$react_month = $_POST['react_month'];
$react_day = $_POST['react_day'];
$react_year = $_POST['react_year'];
$Notes = $_POST['Notes'];
$dtnum = $_POST['dtnum'];
$dtup = $_POST['dtup'];
$pswcon = $_POST['pswcon'];
$usremail = $_POST['usremail'];
$repusrn = $_POST['repusrn'];
$repname1 = $_POST['repname1'];
$repname2 = $_POST['repname2'];
$today = date("F j, Y");
$year = date(Y);
$dtnum = date(Ymd);
$y1 = $year + 1;
$y2 = $year + 2;
$y3 = $year + 3;
if($mkt != 1){
$mkt = 0;
$mktw = 'No';
}else{
$mktw = 'Yes';
}
$dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1');
mysql_select_db('ecosmar_contacts', $dbcnx);
$listem = @mysql_query("SELECT ID,usrn FROM con_main WHERE email='$email' AND Address='$Address'");
if (!$listem) {
die('Error checking for duplicates.
Error: '. mysql_error(). '
');
}
$num_rows = mysql_num_rows($listem);
$dupe = mysql_fetch_array($listem);
$dupeID = $dupe[0];
$dupeusrn = $dupe[1];
?>
|
Eco-$mart, Inc. On-line Administration
|
if($num_rows >= 1 or $num_rows != ""){
echo("" .
"This is a Duplicate Contact |
" .
"
" .
"A Contact at that address is currently registered to $dupeusrn. |
" .
"If you believe this is an error, please contact Eco-\$mart Administration. |
" .
"Return |
" .
"
");
exit();
}
?>
©2007 - Data Base Interface - Custom Built at:
|