#include ../header.iphtml #include ../header_include.iphtml

The is listed by day. Use the tabs below to navigate the .

"; $cursor = $main::dbh->prepare(qq{ SELECT DATE_FORMAT(lecture_date,'%W, %M %e, %Y'), CONCAT_WS(' – ',TIME_FORMAT(start_time,'%l:%i'),TIME_FORMAT(end_time,'%l:%i %p')),lecture,lectureid,main_topic,facultyid,room FROM new_lecture WHERE committeeid=? ORDER BY lecture_date, start_time, facultyid,main_topic }); $cursor->execute($meeting_no) || die "Couldn't execute query: $DBI::errstr\n"; my $firstload = 1; $counter = 1; COMPLETE: while (@ary = $cursor->fetchrow_array()) { my $speaker = ''; my $syllabusCount = 0; if ($dateholder ne $ary[0]) { print "
\n" if !$firstload; print < EOF $dateholder = $ary[0]; $firstload = 0; $counter++; } if ($ary[4] eq "1") { print '"; print getSubLectures($ary[3]); next COMPLETE; } if (!$ary[5]) { print ""; print "\n"; } } $cursor->finish; !>
$ary[0]
'.$ary[2].''; print getSpeakers($ary[3]); print "
$ary[1]$ary[2]"; print getSpeakers($ary[3]); if ($ary[6]) { my $anchor = ''; SWITCH: { $anchor = "#two", last SWITCH if $ary[6] =~ /Level Two/gi; $anchor = "#three", last SWITCH if $ary[6] =~ /3rd/gi; $anchor = "#four", last SWITCH if $ary[6] =~ /4th/gi; $anchor = "#five", last SWITCH if $ary[6] =~ /5th/gi; $anchor = "#six", last SWITCH if $ary[6] =~ /Level Six/gi; } print "
Location: $ary[6]"; } print "
#include ../footer_include.iphtml