include "../admin/connect.phtml";
if (!$sid || !$seminarID) {
$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.";
}
elseif (!$modify && !$delete) {
/* get existing values here */
$eduTypeID = mysql_result($result,$i,"eduTypeID");
$major1TopicID = mysql_result($result,$i,"major1TopicID");
$major2TopicID = mysql_result($result,$i,"major2TopicID");
$seminar = mysql_result($result,$i,"seminar");
$keywords = mysql_result($result,$i,"keywords");
$email = mysql_result($result,$i,"email");
$phone = mysql_result($result,$i,"phone");
$url = mysql_result($result,$i,"url");
$description = mysql_result($result,$i,"description");
}
}
}
}
if ($delete) {
$sql = "delete from Seminar where seminarID=$seminarID";
$result = mysql($database, $sql);
Header("Location: ./seminars.phtml?sid=$sid");
exit;
}
if ($modify) {
$tok = strtok ($required, ",");
while ($tok) {
if (!$$tok) {
$req[] = $tok;
$missing = 1;
}
$tok = strtok (",");
}
if ($missing) {
$errors = "The following fields are mandatory:\n
\n
\n
|