Seminars
echo $curSemName . ' ' . $curYear; ?>
$val = db_connect($dbhost, $dbuser, $dbpass); if(isset($_GET['v']) && $_GET['v'] == 'abstract') { // SID if(!isset($_GET['sid']) OR !is_numeric($_GET['sid'])) { die('No SID or invalid SID specified.'); } else { $sid = $_GET['sid']; } // ## SID $sql = mysql_query(mkRecordQuery($table, $sid)); $data = mysql_fetch_row($sql); if(!$data) { die('Invalid SID specified.'); } echo '« Back to seminars page
'; seminarView($data, '?v=abstract'); } // else { $sqlu = mysql_query(mkListingQuery($table, $curYear, $curSemester, 'upcoming')); $sqlp = mysql_query(mkListingQuery($table, $curYear, $curSemester, 'past')); if(!$sqlu || !$sqlp) { die('Error retrieving data:
' . mysql_error()); } /* ########### # GET UPCOMING SEMINAR ############## global $seminarDate; $upcoming = mysql_fetch_row(mysql_query("SELECT SeminarID, PresenterL, PresenterF, Title, DATE_FORMAT(SeminarDate, '$seminarDate'), SeminarLocation FROM seminars WHERE Semester = '$curSemester' AND SemesterYear = '$curYear' AND SeminarDate >= NOW() AND Title NOT LIKE '%CANCELLED%' ORDER BY SeminarDate ASC LIMIT 0, 1")); if($upcoming) { if($upcoming[3] == 'CANCELLED') { // } else { echo '
Upcoming Seminar:
' .
$upcoming[3] . '
Presenter: ' . $upcoming[2] . ' ' . $upcoming[1] . '' . $upcoming[4] . ' at ' . $upcoming[5] . '
More Information »
'; } } */ // THEN DISPLAY SEMINAR LISTINGS seminarListings($sqlu, '?v=abstract'); // display 'more information' box // display past seminars, if there are any if(mysql_num_rows($sqlp) > 0) { echo '
Past Seminars this Semester
'; seminarListings($sqlp, '?v=abstract'); } } // else echo '
|