Faculty |
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";
// now for post docs
$query="SELECT firstname,shortname,url,title,office,phone FROM instructors WHERE type = 'P' ORDER BY shortname ASC " ;
$result=mysql_query($query) ;
$num=mysql_numrows($result) ;
if ( $num != 0 ) {
print "
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";
} // if $num
$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) ;
if ( $num != 0 ) {
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 ;
} // for $i
}
// 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 "
Graduate Students
|
Name |
Office |
Phone |
Email |
" ;
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, "email" );
$my_room = mysql_result($result, $i, "office" );
$my_phone = mysql_result($result, $i, "phone" );
$line = "
| " ;
$line .= $my_first . " " . $my_teach . " | " ;
$line .= $my_room . " | " . $my_phone ." | " ;
$line .= $my_title . " |
\n" ;
print $line ;
}
print "\n";
mysql_close() ;
?>
MyBGSU
BGSU Email
Search
Directory
Academics
Admissions
The Arts
Athletics
Library
A to Z Links
Bowling Green State University