"; exit(); } list ($year, $month, $day) = split ('-', $Date); list ($sh, $sm, $ss) = split (':', $Time); list ($eh, $em, $es) = split (':', $row[0]); // $HTMLtasks = str_replace("\n","
",$row[10]); // $HTMLneeds = str_replace("\n","
",$row[11]); print <<

Date:
Room:	END; if ($manage ==1) { $query1 = "SELECT RoomNo, Title from SR_room";} else {$query1 = "SELECT RoomNo, Title from SR_room where Status='1'";} $result1 = mysql_query($query1, $connection) or die ("Error in query: $query1. " . mysql_error()); if (mysql_num_rows($result1) >= 1) { while ($row1 = mysql_fetch_row($result1)) { if ($row1[0] == $Room) {print "$row1[1]";} else {print "$row1[1]";} } } print <<
Start:
End:
Class:	END; // $query1 = "SELECT ClassID, CourseID, Days, BeginTime, EndTime from SR_course WHERE InstructorID = '$row[16]'"; $query1 = "SELECT ClassID, CourseID, Days, BeginTime, EndTime from SR_course WHERE InstructorID = '$row[16]' and Year = '$syear' and Semester='$semester'"; $result1 = mysql_query($query1, $connection) or die ("Error in query: $query1. " . mysql_error()); $n_rows = mysql_num_rows($result1); while ($row1 = mysql_fetch_row($result1)) { if ($row1[0] == $row[4]) { print <<$row1[0] $row1[1] $row1[2] From $row1[3] To $row1[4] END; } else { print <<$row1[0] $row1[1] $row1[2] From $row1[3] To $row1[4] END; } } print <<
Instructor:	$row[2] $row[3]
Number of Students:
Tasks:	END; $query1 = "SELECT Task from SR_task WHERE RoomNo = '$Room' and Status='1' order by Place"; $result1 = mysql_query($query1, $connection) or die ("Error in query: $query1. " . mysql_error()); $n_rows = mysql_num_rows($result1); $i = 0; while ($row1 = mysql_fetch_row($result1) and $i<=$n_rows) { $i++; if (strpos($row[10], $row1[0]) === false) { print <<$row1[0] END; } else { print <<$row1[0] END; } }//while print <<
Brief Lesson Plan:	$row[11]

END; } print <<
END; ?>