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"); } elseif ($num > 0 && $submit) { $SeminarDeluxeID = mysql_result($result,0,"SeminarDeluxeID"); } } } } } if ($submit) { if (!$errors) { /* echo "hello";exit; */ $now = Date("Y-m-d h:m:s"); if (!$seminarID) { $sql = "insert into Seminar (SeminarDeluxeID, seminarID,courseObjectives,summary,audience,instructorBio,topics,price,schedule,registrationNumber,accreditation,dateModified,open,image,upsize,active,processed)values ('', $seminarID, '$courseObjectives', '$summary', '$audience', '$instructorBio', '$topics', '$price', '$schedule', '$registrationNumber', '$accreditation', '$now', 0, '', '', 0, 0)"; } else { # if ($SeminarDeluxeID == 0) { # $q = "select SeminarDeluxeID from Seminar order by SeminarDeluxeID desc"; # $aResult = mysql($database, $q); # $aNum = mysql_numrows($aResult); # if ($aNum > 0) { # $SeminarDeluxeID = mysql_result($aResult,0,"SeminarDeluxeID"); # $SeminarDeluxeID++; # $sql = "update Seminar set SeminarDeluxeID='$SeminarDeluxeID', courseObjectives='$courseObjectives', summary='$summary', audience='$audience', instructorBio='$instructorBio', topics='$topics', price='$price', schedule='$schedule', registrationNumber='$registrationNumber', accreditation='$accreditation', dateModified='$now' where seminarID=$seminarID"; # } else { # $sql = "update Seminar set courseObjectives='$courseObjectives', summary='$summary', audience='$audience', instructorBio='$instructorBio', topics='$topics', price='$price', schedule='$schedule', registrationNumber='$registrationNumber', accreditation='$accreditation', dateModified='$now' where seminarID=$seminarID"; # } # } else { $sql = "update Seminar set courseObjectives='$courseObjectives', summary='$summary', audience='$audience', instructorBio='$instructorBio', topics='$topics', price='$price', schedule='$schedule', registrationNumber='$registrationNumber', accreditation='$accreditation', dateModified='$now' where seminarID=$seminarID"; # } } /* echo $sql; exit; */ $result = mysql($database, $sql); $message = "Thank you! Your seminar deluxe listing has been successfully submitted.
Please allow up to 3 days for approval."; $encMessage = UrlEncode($message); Header("Location: ./seminars.php3?sid=$sid&message=$encMessage\n\n"); exit; } } if ($errors) { $errors = "
$errors
\n
\n"; } $template = File("delseminartemp.html"); $i=0; while ($i