include ("include/cv/global_var.inc") ?>
include ("include/cv/search_functions.inc") ?>
$username = get_username($id, 'personal');
$db = mysql_connect($host, $db_user, $db_password);
mysql_select_db($database,$db);
$query = "SELECT * FROM personal p
LEFT JOIN departments d ON p.department = d.nickname
WHERE username='$username'
ORDER BY lastn";
$result = mysql_query($query, $db) or die(mysql_error($result) . __LINE__);
while ( $row = mysql_fetch_assoc($result) ) {
$urls = get_urls($row[username], 'public');
$email = get_email($row[username], 'public');
$phone_numbers = get_phone_numbers($row[username], 'public');
$phone_count = count($phone_numbers);
$email_count = count($email);
$urls_count = count($urls);
$title = $row[title];
$addl_title1 = $row[addl_title1];
$addl_title2 = $row[addl_title2];
$dept_name = $row[d.nickname];
$department = $row[department];
$office = $row[office];
$firstn = $row[firstn];
$lastn = $row[lastn];
}
?>
include("include/leftnav/people.inc"); ?>
if ( $department=='me' or $username='asdouglas' ) { ?>
switch ($item) {
case "g":
include ("include/cv/general.inc");
break;
case "e":
include ("include/cv/ex_ed.inc");
break;
case "sp":
include ("include/cv/selected_publications.inc");
break;
case "aa":
include ("include/cv/administrative-assist.inc");
break;
case "con":
default:
include ("include/cv/return_personal.inc");
}
?>
} else {
print "The faculty member requested is not a member of Mechanical Engineering.";
}
?>