Instructors

Active in END; $query = "select Year, Semester from SR_semester order by StartDate desc"; $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); while ($row = mysql_fetch_row($result)){ if ($row[1]==$semester && $row[0]==$syear){ print <<$row[1] $row[0] END; } else { print <<$row[1] $row[0] END; } } print << Long Format Short Format

END; if ($format == "1") { print <<Extension END; } print << END; if ($term == " "){ $query = "SELECT Department, LastName, FirstName, InstructorID, Email, Extension, Home, Cell from SR_instructor where 1=1"; } else { $query = "SELECT distinct Department, LastName, FirstName, i.InstructorID, Email, Extension, Home, Cell from SR_instructor i, SR_course c where c.Year='$syear' and c.Semester='$semester' and c.InstructorID=i.InstructorID"; } if ($dpt != '') {$query .= " and Department='$dpt'";} $query .= " order by Department, LastName"; $id = 1; // print $query; $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); $bgcolor = '#DDDDDD'; while ($row = mysql_fetch_row($result)) { print << END; if ($format == "1") { print <<$row[5] END; $id +=1; } print << END; if ($bgcolor == '#DDDDDD'){$bgcolor = '#FFFFEE';}else{$bgcolor = '#DDDDDD';} } print <<
END; ?>

 

dired link

ID

Department

Last Name

First Name

Email

Home

Cell

Edit

Delete

$id

$row[0]

$row[1]

$row[2]

$row[4]

$row[6]

$row[7]

Edit

Delete