\n";
if($phd_year_post != "" || $ms_year_post != "") {
if($phd_year_post != "") {
// get all names from this semester/year
print "\n";
$phd_year_query = "select * from alumni where phd_year = '$phd_year_post' order by lname asc";
$phd_year_result = mysql_query($phd_year_query);
$phd_year_num = mysql_numrows($phd_year_result);
print "
\n";
for($i = 0; $i < $phd_year_num; $i++)
{
$phd_lname = mysql_result($phd_year_result, $i, "lname");
$phd_fname = mysql_result($phd_year_result, $i, "fname");
$phd_uid = mysql_result($phd_year_result, $i, "id");
$phd_advisor = mysql_result($phd_year_result, $i, "advisor");
if($phd_advisor == "")
{
$phd_advisor = "n/a";
}
print "- $phd_lname, $phd_fname - $phd_advisor
\n";
}
print "
\n";
print "
";
}
}
else {
$phd_year_query = "select distinct phd_year from alumni order by phd_year desc";
$phd_year_result = mysql_query($phd_year_query);
$phd_year_num = mysql_numrows($phd_year_result);
?>
\n";
if($ms_year_post != "" || $phd_year_post != "") {
if($ms_year_post != "") {
// get all names from this semester/year
print "\n";
$ms_year_query = "select * from alumni where ms_year = '$ms_year_post' order by lname asc";
$ms_year_result = mysql_query($ms_year_query);
$ms_year_num = mysql_numrows($ms_year_result);
print "
\n";
for($i = 0; $i < $ms_year_num; $i++) {
$ms_lname = mysql_result($ms_year_result, $i, "lname");
$ms_fname = mysql_result($ms_year_result, $i, "fname");
$ms_uid = mysql_result($ms_year_result, $i, "id");
$ms_advisor = mysql_result($ms_year_result, $i, "advisor");
if($ms_advisor == "") {
$ms_advisor = "n/a";
}
print "- $ms_lname, $ms_fname - $ms_advisor
\n";
}
print "
\n";
print "
";
}
}
else {
$ms_year_query = "select distinct ms_year from alumni order by ms_year desc";
$ms_year_result = mysql_query($ms_year_query);
$ms_year_num = mysql_numrows($ms_year_result);
?>