//This is the signup-form page.
//Logic:
//If recordCount <> 1 -> go to eventInfo.php
// (either no events [0], or invalid ID[0] or no ID[>1])
//if recordCount == 1 -> stay
// (valid ID or just one record exists)
$eventID = $_REQUEST["eventID"];
if ($eventID) {
$query = "SELECT * FROM eventInfo WHERE eventID = " . $eventID;
} else {
$query = "SELECT * FROM eventInfo WHERE hideEvent <> 'checked' ORDER BY eventID DESC";
}
$table = "eventInfo";
include("sharedCode/dbConnect.php");
$eventsList = mysql_query($query);
mysql_close($link);
$recordCount = mysql_numrows($eventsList);
if ($recordCount != 1) {
$forwardPath = "eventInfo.php";
header ("Location: $forwardPath");
} //else $recordCount == 1, and control-flow continues...
$eventID = mysql_result($eventsList, 0, "eventID"); //in case no eventID was given, otherwise harmlessly redundant
$eventName = mysql_result($eventsList, 0, "name");
$day = mysql_result($eventsList, 0, "day");
$time = mysql_result($eventsList, 0, "time");
$description = mysql_result($eventsList, 0, "description");
$thankYouSubject = mysql_result($eventsList, 0, "thankYouSubject");
$thankYouNote = mysql_result($eventsList, 0, "thankYouNote");
$contactName = mysql_result($eventsList, 0, "contactName");
$contactEmail = mysql_result($eventsList, 0, "contactEmail");
$contactMore = mysql_result($eventsList, 0, "contactMore");
$hideEvent = mysql_result($eventsList, 0, "hideEvent");
$isolateEvent = mysql_result($eventsList, 0, "isolateEvent");
if (!$hideEvent) {$hideEvent = "";}
?>
EBSCO Publishing Conference Event Registration