$show_id = $_GET['show'];
if (empty($show_id)) {
?>

}
$show_exists = mysql_query("SELECT id FROM wp_wcs2_class WHERE id = $show_id") or die(mysql_error());
while($info = mysql_fetch_array( $show_exists ))
{
$show_does_exist = $info['id'];
}
if (empty($show_does_exist)) {
?>

} else {

$show_info = mysql_query("SELECT class_id, classroom_id, weekday, start_hour, end_hour FROM wp_wcs2_schedule WHERE class_id = $show_id") or die(mysql_error());
while($info = mysql_fetch_array( $show_info ))
{
$program_id = $info['class_id'];
$genre_id = $info['classroom_id'];
$weekday_id = $info['weekday'];
$start_hour = $info['start_hour'];
$end_hour = $info['end_hour'];
}

$program_info = mysql_query("SELECT class_name, class_description, class_announcements, class_playlist FROM wp_wcs2_class WHERE id = $program_id") or die(mysql_error());
while($info = mysql_fetch_array( $program_info ))
{
$program_name = $info['class_name'];
$program_description = $info['class_description'];
$program_announcements = $info['class_announcements'];
$program_playlist = $info['class_playlist'];
}

$host_info = mysql_query("SELECT wp_users.display_name FROM wp_users INNER JOIN wp_wcs2_class ON wp_users.ID = wp_wcs2_class.host_id WHERE wp_wcs2_class.id = $show_id;") or die(mysql_error());
while($info = mysql_fetch_array( $host_info ))
{
$instructor_name = $info['display_name'];
}

$genre = mysql_query("SELECT classroom_name FROM wp_wcs2_classroom WHERE id = $genre_id") or die(mysql_error());
while($info = mysql_fetch_array( $genre ))
{
$genre_name = $info['classroom_name'];
}

if ($weekday_id == 0) {
$weekday_name = "Sunday";
} elseif ($weekday_id == 1) {
$weekday_name = "Monday";
} elseif ($weekday_id == 2) {
$weekday_name = "Tuesday";
} elseif ($weekday_id == 3) {
$weekday_name = "Wednesday";
} elseif ($weekday_id == 4) {
$weekday_name = "Thursday";
} elseif ($weekday_id == 5) {
$weekday_name = "Friday";
} elseif ($weekday_id == 6) {
$weekday_name = "Saturday";
}

?>