Postdocs
Name |
Title |
Office |
Phone |
" ;
for ( $i = 0 ; $i < $num ; $i++ ) {
$myurl = mysql_result($result, $i, "url") ;
$my_first = mysql_result($result, $i, "firstname" ) ;
$my_teach = mysql_result($result, $i, "shortname" ) ;
$my_title = mysql_result($result, $i, "title" );
$my_room = mysql_result($result, $i, "office" );
$my_phone = mysql_result($result, $i, "phone" );
$line = "| " ;
$line .= $my_first . " " . $my_teach . " | " . $my_title . " | " ;
$line .= $my_room . " | " . $my_phone ." | \n" ;
print $line ;
} // for $i
print " \n |
\n";
} // if $num
// now for staff
$query="SELECT firstname,shortname,url,title,office,phone FROM instructors WHERE type = 'S' ORDER BY shortname ASC " ;
$result=mysql_query($query) ;
$num=mysql_numrows($result) ;
print "
Staff
Name |
Title |
Office |
Phone |
" ;
for ( $i = 0 ; $i < $num ; $i++ ) {
$myurl = mysql_result($result, $i, "url") ;
$my_first = mysql_result($result, $i, "firstname" ) ;
$my_teach = mysql_result($result, $i, "shortname" ) ;
$my_title = mysql_result($result, $i, "title" );
$my_room = mysql_result($result, $i, "office" );
$my_phone = mysql_result($result, $i, "phone" );
$line = "| " ;
$line .= $my_first . " " .$my_teach . " | " . $my_title . " | " ;
$line .= $my_room . " | " . $my_phone ." | \n" ;
print $line ;
}
print " \n |
\n" ;
// grad students
$query="SELECT firstname,shortname,url,email,office,phone FROM instructors WHERE type = 'G' AND name != 'Staff' ORDER BY shortname ASC " ;
$result=mysql_query($query) ;
$num=mysql_numrows($result) ;
print "
