Contact:
|
|
Event Type:
|
|
Project ID: |
About:
|
|
$dbcnx = @mysql_connect('mysql.plainhost.com','ecosmar_ecosmart','ecoman1');
mysql_select_db('ecosmar_contacts', $dbcnx);
$ok = @mysql_query("INSERT INTO con_reactivity SET CID='$CONID',react_year='$year',react_month='$mo',react_day='$day',usrn='$usrn',dtnum='$dtnum'");
if (!$ok){
echo("Error Adding to Contact Report!".
"Error:" . mysql_error() . " |
");
}
mysql_select_db('ecosmar_friendly', $dbcnx);
$ok2 = @mysql_query("SELECT ID FROM calendar WHERE dtnum='$dtnum'");
if (!$ok2){
echo("Could not get Calendar Info".
"Error:" . mysql_error() . " |
");
}
$read = mysql_fetch_array($ok2);
$readit = $read[0];
if($readit != "integer"){
$ok3 = @mysql_query("INSERT INTO calendar SET yearnum='$year',monthnum='$mo',daynum='$day',dtnum='$dtnum',dtup='$dtnum',usrn='$usrn'");
if (!$ok3){
echo("Error Adding to Calendar!".
"Error:" . mysql_error() . " |
");
}
}
$GID = mysql_result($ok3);
$ok4 = @mysql_query("INSERT INTO dates SET CALID='$GID',PID='$PID',CONID='$CONID',title='$title',note='$note',time='$tid',min='$min',dtnum='$dtnum',usrn='$usrn'");
if (!$ok4){
echo("Error Setting Event!".
"Error:" . mysql_error() . " |
");
}else{
echo("Success! |
");
}
?>
Return
|