query("SELECT * FROM uhswvcom_himg.physician WHERE physician_id = " . $_GET['p']); if($database->numberofrows() == 0) header("location: index.php"); $row = $database->getrow(); require_once ('inc/inc.header.php'); require_once ('inc/inc.navigation.php'); ?>

Physician Profile

query("SELECT specialty_name FROM uhswvcom_himg.specialty s NATURAL JOIN uhswvcom_himg.physician_specialty ps WHERE ps.physician_id = " . $row['physician_id']); echo "" . $row['physician_first'] . " " . $row['physician_middle'] . " " . $row['physician_last'] . ", " . $row['physician_title'] . "

"; echo "Phone: " . $row['physician_phone'] . "
"; echo "Fax: " . $row['physician_fax'] . "
"; if ($specialties->numberofrows() > 0) { echo "Specialty: "; for ($j=0; $j<$specialties->numberofrows(); $j++) { $specialty = $specialties->getrow(); if ($j == $specialties->numberofrows() - 1) echo $specialty['specialty_name']; else echo $specialty['specialty_name'] . ", "; } } echo "

"; if ($row['physician_internship'] != NULL) echo "Internship: " . $row['physician_internship'] . "
"; if ($row['physician_medicalschool'] != NULL) echo "Medical School: " . $row['physician_medicalschool'] . "
"; if ($row['physician_residency'] != NULL) echo "Residency: " . $row['physician_residency'] . "
"; if ($row['physician_fellowship'] != NULL) echo "Fellowship: " . $row['physician_fellowship'] . "
"; if ($row['physician_startyear'] != NULL) echo "HIMG: " . $row['physician_startyear'] . "
"; if ($row['physician_biography'] != NULL) { echo "

" . $row['physician_biography'] . "
"; } ?>