Student Directory

Narrow Your Search:  
" .$row['letter'] .""; echo " "; } echo "

"; } function getPeople($roles) { // List people $query = " SELECT CONCAT(first_name,' ',middle_name,' ',last_name) AS allnames, LEFT(last_name,1) AS letter, group_concat(' ',role_name) AS new_role_name, panda_people.person_id, email_address, url_image, url_web, url_text, url2_web, url2_text, directory_description, office_primary, office_secondary, phone_primary, phone_secondary, panda_roles.role_id FROM panda_people, panda_people_roles, panda_roles WHERE panda_people.person_id = panda_people_roles.person_id AND panda_people_roles.role_id IN $roles AND panda_roles.role_id = panda_people_roles.role_id AND active = 1 GROUP BY last_name, first_name "; $get_people = doQuery($query); return $get_people; } if ($view == "alpha") { $get_person = getPeople($roles); writeAlphabet($roles); $cur_letter = ""; while ($row = mysql_fetch_assoc($get_person)){ //draw a line if new letter is not the first letter if (($row['letter'] != $cur_letter) && ($cur_letter != "")) echo "
"; //write new letter if ($row['letter'] != $cur_letter) echo "
" .$row['letter'] ."
"; // direct back to top if new letter is not the first letter if (($row['letter'] != $cur_letter) && ($cur_letter != "")) echo "
back to top

"; $cur_letter = $row['letter']; echo "

" .$row['allnames'] .""; if (!$row['title_primary']) $title= $row['new_role_name']; else $title = $row['title_primary']; echo ", " .$title; echo "
"; if ($row['office_primary']) echo "Office: " .$row['office_primary'] ." ~ "; if ($row['phone_primary']) echo "Phone: " .$row['phone_primary'] ." ~ "; if ($row['email_address']) echo "Email: " .$row['email_address'] ."

"; } } if ($view == "undergrad") { include('/var/www/webroot/pandaweb/undergraduate/students.inc'); } if ($view == "grad") { include('/var/www/webroot/pandaweb/graduate/students.inc'); } if ($view == "alumni") { include('/var/www/webroot/pandaweb/people/alumni/alumni.inc'); } dbClose(); ?>