People
Go to:   Faculty    Students    Alumni
Faculty "; $query="Select * from people where catid=1 order by last_name asc;"; $res=mysql_query($query) or die (mysql_error()); while ($field=mysql_fetch_array($res)){ echo "\n"; echo " | ".$field['first_name']." ".$field['last_name'].", ".$field['current_position']." |
Current Position: ".$field['current_position']." | |
Interest: ".$field['research_interest']." | |
Homepage:".$field['homepage']." | |
Other links: ".$field['olink1']."  ".$field['olink2']." | |
"; } echo "
Students
"; $query="Select * from people where catid=2 order by last_name asc;"; $res=mysql_query($query) or die (mysql_error()); while ($field=mysql_fetch_array($res)){ echo "".$field['first_name']." ".$field['last_name'].", ".$field['current_position']." | ".$field['first_name']." ".$field['last_name']."\n"; } } else{ if ($field['height']>$field['width']){ if ($field['height']>80){ $pheight=80; $pwidth=round($field['width']/$field['height']*80); } else{ $pheight=$field['height']; $pwidth=$field['width']; } } else{ if ($field['width']>80){ $pwidth=80; $pheight=round($field['height']/$field['width']*80); } else{ $pheight=$field['height']; $pwidth=$field['width']; } } if ($field['photoname']==""){ echo " | \n"; } else{ echo " | \n"; } echo " | ".$field['first_name']." ".$field['last_name'].", ".$field['current_position']." | \n"; //echo "
Current Position: ".$field['current_position']." | |
Interest: ".$field['research_interest']." | |
Homepage:".$field['homepage']." | |
  ".$field['otherinfo']." |
"; } echo "
Alumni
"; $query="Select first_name,last_name from people where catid=3 order by last_name asc;"; $res=mysql_query($query) or die (mysql_error()); while ($field=mysql_fetch_array($res)){ echo "".$field['first_name']." ".$field['last_name'].",".$field['current_position']." | ".$field['first_name']." ".$field['last_name']."\n"; } } else{ if ($field['height']>$field['width']){ if ($field['height']>80){ $pheight=80; $pwidth=round($field['width']/$field['height']*80); } else{ $pheight=$field['height']; $pwidth=$field['width']; } } else{ if ($field['width']>80){ $pwidth=80; $pheight=round($field['height']/$field['width']*80); } else{ $pheight=$field['height']; $pwidth=$field['width']; } } if ($field['photoname']==""){ echo " | \n"; } else{ echo " | \n"; } echo " | ".$field['first_name']." ".$field['last_name'].", ".$field['current_position']." | \n"; //echo "
Current Position: ".$field['current_position']." | |
Interest: ".$field['research_interest']." | |
Homepage:".$field['homepage']." | |
  ".$field['otherinfo']." |
"; } ?>