END; } else { print <<My Account | Change Password | Sign Out END; } print <<

Cancel this reservation

END; if ($Date <> '') { $query = "SELECT SR_reservation.EndTime, CourseID, FirstName, LastName, SR_reservation.ClassID, Home, Cell, Extension, Email, SR_reservation.StudentNum, Tasks, SpecialNeeds, CourseTitle, Days, SR_course.BeginTime, SR_course.EndTime, SR_reservation.InstructorID from SR_reservation, SR_instructor, SR_course WHERE Date = '$Date' and "; $query .= "StartTime='$Time' and SR_reservation.RoomNo='$Room' and SR_reservation.ClassID=SR_course.ClassID and SR_reservation.InstructorID=SR_instructor.InstructorID and CONCAT(SR_course.Semester, ' ', SR_course.Year) = '$Semester'"; $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); $row = mysql_fetch_row($result); if ($manage == 0 && $ID != $row[16]) { print "You can not cancel this reservation.
"; 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:
 $month/$day/$year
Room:
 $Room
Start:
 $sh:$sm
End:
 $eh:$em
Class:
 $row[4] - $row[1] -- $row[12]   $row[13]   From $row[14] to $row[15]
Instructor:
 $row[2] $row[3]
Number of Students:
 $row[9]
Email:
 $row[8]
Extension:
 $row[7]
Home Phone:
 $row[5]
Cell Phone:
 $row[6]
Tasks:
 $HTMLtasks
Brief Lesson Plan:
 $HTMLneeds
Reason to cancel this reservation: END; if ($manage==1){ print <<Absent END; } print <<

END; } print <<
END; ?>

 

dired link