| |
|
|
| Order
|
Error performing query: " . mysql_error() .
"");
}
while($table_row=mysql_fetch_array($table_query_result)) {
$occupations[$table_row['Number']]=$table_row['Name'];
}
if ($_GET['id'] == 'alphabet') {
$alumni_query_result=mysql_query('SELECT * FROM Students ' . 'WHERE Member=0 ' . 'ORDER BY LastName,FirstName,OSUID', $db);
}
else if ($_GET['id'] == 'byYear') {
$alumni_query_result=mysql_query('SELECT * FROM Students ' . 'WHERE Member=0 ' . 'ORDER BY DegreeYear DESC,LastName,FirstName,OSUID', $db);
}
else if ($_GET['id'] == 'byOccup') {
$alumni_query_result=mysql_query('SELECT * FROM Students ' . 'WHERE Member=0 ' . 'ORDER BY Occupation,LastName,FirstName,OSUID', $db);
}
else {
$alumni_query_result=mysql_query('SELECT * FROM Students ' . 'WHERE Member=0 ' . 'ORDER BY LastName,FirstName,OSUID', $db);
}
if (!$alumni_query_result)
{
exit('There was a technical problem connecting to the ' .
'alumni database. Try again later.');
}
$Degree_Year='1';
$Occup_n='something';
while ($alumni_row=mysql_fetch_array($alumni_query_result))
{
if ($_GET['id'] == 'byYear') {
if ($Degree_Year != $alumni_row['DegreeYear']) { ?>
|
|
 |
2){ ?> ( )
0) { ?>
Current occupation:
0) { ?>
Institution:
0)
{
$advisorid[$advisorsfound]=$advisor_row['Advisor'];
$advisorname[$advisorsfound++] = $facultynames[$advisor_row['Advisor']];
}
}
if ($advisorsfound)
{
?>
OSU Advisor1) {echo('s');}?> : ");
printf($advisorname[$j] . "");
}
$advisorsprinted=1;
?> ');
if (strlen($email)>0)
{ ?>
PubMed
|
|