"; require $_SERVER['DOCUMENT_ROOT'].'/format/header.html'; print " RGS: Staff Directory "; require $_SERVER['DOCUMENT_ROOT'].'/format/userBar.html'; require $_SERVER['DOCUMENT_ROOT'].'/format/layout.html'; /*---End Page Formatting---------------------*/ /*---Begin Required PHP Scripts--------------*/ require $_SERVER['DOCUMENT_ROOT'].'/phpScripts/connect.php'; /*---End Required PHP Scripts----------------*/ /*---Begin Page Content----------------------*/ $staffQuery = "SELECT * FROM `staff` LIMIT 0 , 200"; $staffResult = mysql_query($staffQuery) or die("Unable to Poll Staff Directory"); print "

Staff Directory
"; $i=-1; while(($staffMember = mysql_fetch_row($staffResult) ) != NULL) { $FName = $staffMember[1]; $LName = $staffMember[2]; $dept = $staffMember[3]; $email = $staffMember[4]; $ext = $staffMember[5]; $respon = $staffMember[6]; $i++; if($i==2) { $i=0; print""; } print " "; } print"
$LName, $FName
Department$dept
Title$respon
Ext$ext
E-mail$email
"; /*--------------------------------------------------------------------------------------*/ /*Closing Footer Files*/ include $_SERVER['DOCUMENT_ROOT'].'/close.html'; /*------------------------------------------------------------------------------------*/ ?>