Personnel " ); // insert the picture if( $memb['member_pictureURL'] == "" ) { echo( "" ); } else { echo( "" ); } echo( "" ); // insert table spacer echo( "" ); // insert person info echo( "" ); echo( $memb['member_title'] ); echo( " " ); echo( $memb['member_forename'] ); echo( " " ); echo( $memb['member_surname'] ); echo( "" ); // insert the title - we'll have to link tables here echo( "
" ); // echo( $memb['member_status'] ); // this is the member status no. //lets find out what the member status is $statusID = $memb['member_status']; $statusQuery = "SELECT status_name FROM staffstatus WHERE status_id='$statusID'"; $status=mysql_query($statusQuery); $stat = mysql_fetch_array( $status ); echo( $stat['status_name'] ); echo( "" ); // insert e-mail echo( "
 

"); echo( $memb['member_email'] ); echo( "
" ); //insert computing dept information (must come from db) echo( "

Computing Department
Faculty of Applied Sciences
Engineering Building
Lancaster University
Lancaster, UK
LA1 4YR

Room: " ); echo( $memb['member_room'] ); echo( "
Tel: " ); echo( $memb['member_phone'] ); echo( "
Fax: " ); echo( $memb['member_fax'] ); echo( "

" ); if( $memb['member_homepageURL'] == "" ) { // do nothing } else { echo( "

Visit my homepage at " ); echo( ""); echo( $memb['member_homepageURL'] ); echo( "" ); } } else { //////////////////////////////// // If they didn't include all the required fields set a variable // and keep going. //////////////////////////////// $notall = 1; echo( "

You must select a person from our staff list to view this page." ); echo( "
Visit the Computing Department Staff List

" ); } } // ?>