include "../admin/connect.phtml"; if (!$sid) { $errors = "Sorry - required parameters not passed."; } else { $sql = "select * from Sid where sid='$sid'"; $result = mysql($database, $sql); $num = mysql_numrows($result); if ($num == 0) { $errors = "Sorry - invalid sid."; } else { $companyID = mysql_result($result,0,"companyID"); $sql = "select * from Company where companyID=$companyID"; $result = mysql($database, $sql); $num = mysql_numrows($result); if ($num == 0) { $errors = "Sorry - invalid companyID."; } else { $company = mysql_result($result,0,"company"); $sql = "select * from Seminar where seminarID=$seminarID and companyID=$companyID"; $result = mysql($database, $sql); $num = mysql_numrows($result); if ($num == 0) { $errors = "Sorry - seminar and company do not match."; } else { /* $sql = "select * from SeminarDeluxe where seminarID=$seminarID"; */ $sql = "select * from Seminar where seminarID=$seminarID"; $result = mysql($database, $sql); $num = mysql_numrows($result); if ($num > 0 && !$submit) { $seminarDeluxeID = mysql_result($result,0,"seminarDeluxeID"); $courseObjectives = mysql_result($result,0,"courseObjectives"); $summary = mysql_result($result,0,"summary"); $audience = mysql_result($result,0,"audience"); $instructorBio = mysql_result($result,0,"instructorBio"); $price = mysql_result($result,0,"price"); $schedule = mysql_result($result,0,"schedule"); $registrationNumber = mysql_result($result,0,"registrationNumber"); $accreditation = mysql_result($result,0,"accreditation"); $topics = mysql_result($result,0,"topics"); } } } } } /* if ($submit) { if (!$errors) { $now = Date("Y-m-d h:m:s"); if (!$seminarDeluxeID) { $sql = "insert into SeminarDeluxe values ('', $seminarID, '$courseObjectives', '$summary', '$audience', '$instructorBio', '$topics', '$price', '$schedule', '$registrationNumber', '$accreditation', '$now', 0, '', '', '', 0, 0)"; } else { $sql = "update SeminarDeluxe set courseObjectives='$courseObjectives', summary='$summary', audience='$audience', instructorBio='$instructorBio', topics='$topics', price='$price', schedule='$schedule', registrationNumber='$registrationNumber', accreditation='$accreditation', dateModified='$now' where seminarDeluxeID=$seminarDeluxeID"; } $result = mysql($database, $sql); Header("Location: ./seminars.phtml?sid=$sid"); exit; } } */ if ($errors) { $errors = "