Faculty and Staff Directory


"; @mysql_select_db ( $db ) or die ("Cant open $db; ".mysql_error() ); //echo "Successfully connected to database...

"; $result = mysql_query($query); $num_results = mysql_num_rows($result); if ($num_results=="0") { echo "Sorry, your search produced no results, please try again."; } else { echo "
"; echo "
"; echo "\n"; print "\n"; if ($toggle=="all_dept") print "\t\n"; else print "\t\n"; if ($toggle=="all_dept") print ""; else print "\t\n"; print "\t\n"; if ($toggle=="all_dept") print ""; else print "\t\n"; if ($toggle=="all_dept") print "\t\n"; else print "\t\n"; print "\t\n"; print "\t\n"; print ""; while ( $a_row = mysql_fetch_array( $result ) ) { //print "\t\n"; if (!(mysql_real_escape_string($a_row['first']))=="") print ""; else print ""; print "\t"; if (!(mysql_real_escape_string($a_row['url']))=="") print"\n"; else print"\n"; if ($toggle=="all_dept") print ""; else { if ((mysql_real_escape_string($a_row['first']))=="") print"\n"; else print"\n"; } if (!(mysql_real_escape_string($a_row['pre']))=="") print "\n"; else print "\n"; if ($toggle=="all_dept") print ""; else{ if ((mysql_real_escape_string($a_row['position']))=="") print"\n"; else print "\n"; } if ((mysql_real_escape_string($a_row['area']))=="") print"\n"; else print"\n"; if ((mysql_real_escape_string($a_row['location']))=="") print"\n"; else print"\n"; if ($toggle=="all_dept") print"\n"; else print"\n"; print "\n"; } echo "
 Department: Last/Department Name: First Name: Ext: Position: Area: Area: Location: Email:

".$a_row['last']."".$a_row['last']." ".$a_row['first']."".$a_row['pre']."-".$a_row['ext']."ext: ".$a_row['ext']." ".$a_row['position']." ".$a_row['area']." ".$a_row['location']." ".$a_row['hours']." ".$a_row['email']."
"; echo "
"; echo "
"; } ?>