$dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_webadmin', 'istration');
mysql_select_db('ecosmar_website', $dbcnx);
$id = $_POST['id'];
$event_month = $_POST['event_month'];
if($event_month == 'January'){
$month = '01';
}elseif($event_month == 'February'){
$month = '02';
}elseif($event_month == 'March'){
$month = '03';
}elseif($event_month == 'April'){
$month = '04';
}elseif($event_month == 'May'){
$month = '05';
}elseif($event_month == 'June'){
$month = '06';
}elseif($event_month == 'July'){
$month = '07';
}elseif($event_month == 'August'){
$month = '08';
}elseif($event_month == 'September'){
$month = '09';
}elseif($event_month == 'October'){
$month = '10';
}elseif($event_month == 'November'){
$month = '11';
}elseif($event_month == 'December'){
$month = '12';
}
$event_d = $_POST['event_day'];
$daylong = strlen($event_d);
if($daylong < 2){
$event_day = '0'.$event_d;
}else{
$event_day = $event_d;
}
$year = $_POST['year'];
$dtonum = $year.$month.$event_day;
$dtnum = $dtonum + 0;
$event_name = $_POST['event_name'];
$event_city = $_POST['event_city'];
$event_state = $_POST['event_state'];
$description = $_POST['event_desc'];
$descript = stripslashes($description);
$descrip = str_replace ( "'", "’", $descript);
$descr = str_replace ( '"', """, $descrip);
$event_desc = $descr;
$info1_type = $_POST['info1_type'];
$info1 = $_POST['info1'];
$info2_type = $_POST['info2_type'];
$info2 = $_POST['info2'];
$info3_type = $_POST['info3_type'];
$info3 = $_POST['info3'];
$ok = @mysql_query("UPDATE calendar05 SET event_month ='$event_month',event_day='$event_day',year='$year',event_name='$event_name',event_city='$event_city',event_state='$event_state',event_desc='$event_desc',
info1_type='$info1_type',info1='$info1',info2_type='$info2_type',info2='$info2',info3_type='$info3_type',info3='$info3',dtnum='$dtnum' WHERE ID = '$id'");
if (!$ok) {
echo("
Error updating Event in Data Base!
".
'Error:' . mysql_error() . '
');
}else{echo("
Event Updated Successfully
");
}
?>