$dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1');
mysql_select_db('ecosmar_contacts', $dbcnx);
$ok = @mysql_query("UPDATE con_main SET first_Name='$first_Name',Name='$Name',Title='$Title',Company='$Company',biztype='$biztype',Phone='$Phone',Address='$Address',FAX='$FAX',City='$City',email='$email',mkt='$mkt',State='$State',ZipCode='$ZipCode',alt_con='$alt_con',alt_title='$alt_title',alt_email='$alt_email',Link='$Link',dtnum='$dtnum',usrn='$repusrn',usremail='$usremail',referred_by='$referred_by',ref_RID='$referrer' WHERE ID='$ID'");
if ($ok) {
echo("
Successful Update to Contact Data Base
" .
"Return to Contact Page
");
}else{die ("
Error Updating Contact to Data Base!
".
'Error:' . mysql_error() . '
');
}
if($act_month != ""){
$ok2 = @mysql_query("INSERT INTO con_activity SET CID='$ID',act_year='$act_year',act_month='$act_month',act_day='$act_day',contact_type='$contact_type',act_respond='$act_respond',usrn='$repusrn',dtnum='$dtnum'");
if ($ok2) {
echo("
Successful Update to Activity Report
");
}else{die ("
Error Updating to Activity Report!
".
'Error:' . mysql_error() . '
');
}
}
if($react_month != ""){
$ok2b = @mysql_query("DELETE FROM con_reactivity WHERE CID='$ID'");
if (!$ok2b) {
echo("
Problem with Re-contact
");
}
$ok2c = @mysql_query("INSERT INTO con_reactivity SET CID='$ID',react_year='$react_year',react_month='$react_month',react_day='$react_day',usrn='$repusrn',dtnum='$dtnum'");
if ($ok2c) {
echo("
Successful Re-contact Set
");
}else{echo ("
Error Setting Re-contact!
".
'Error:' . mysql_error() . '
');
}
}
if($Notes != ""){
$ok3 = @mysql_query("INSERT INTO con_notes SET CID='$ID',Notes='$Notes',usrn='$repusrn',dtnum='$dtnum'");
if ($ok3) {echo("
Successful Update to this Contact's Notes
");
}else{echo ("
Error Updating Contact's Notes!
".
'Error:' . mysql_error() . '
');
}
}
?>