");
$myrow = mysql_fetch_array($result,MYSQL_ASSOC);
$lname = $myrow["lname"];
$fname = $myrow["fname"];
$cname = $myrow["cname"];
$department = $myrow["department"];
$major = $myrow["major"];
$class = $myrow["class"];
$degree = $myrow["degree"];
$city = $myrow["city"];
$state = $myrow["state"];
$major_field= $myrow["major_field"];
$occupation= $myrow["occupation"];
$expertise= $myrow["expertise"];
$industries= $myrow["industries"];
$hobby = $myrow["hobby"];
$profile = $myrow["profile"];
$nameid = $myrow["pname"];
printf(" %s
\n", "Alumni Profile");
$filename = 'img/profile/' . $nameid . '.jpg' ;
if (file_exists($filename)) {
printf(" %s %s %s
\n",$fname,$lname,$cname,$nameid);
} else {
printf(" %s %s %s
\n",$fname,$lname,$cname);
}
printf("Department in SCUT: %s
\n",$department);
#printf("\n",$department);
printf("Major in SCUT: %s
\n", $major);
#printf("\n",$major);
printf("Year Enrolled for Highest degree in SCUT: %s
\n", $class);
printf("Highest degree in SCUT: %s
\n", $degree);
#printf("\n",$degree);
#printf("%s\n",$state);
$result_state=mysql_query("SELECT * FROM states order by kk",$db);
$statename="";
while (
$myrow = mysql_fetch_array($result_state,MYSQL_ASSOC) ) {
$ST = $myrow["ST"];
$STATE_NAME = $myrow["STATE"];
$COUNTRY = $myrow["COUNTRY"];
if ($STATE_NAME == $state || $ST==$state) {
$statename=$STATE_NAME;
break;
}
}
printf("Location: %s, %s
\n",$city,$statename);
#printf("\n",$city,$state);
#printf("Descriptions
\n");
$result_m=mysql_query("SELECT * FROM major order by kk",$db);
$major_fields_name="";
while (
$myrow = mysql_fetch_array($result_m,MYSQL_ASSOC) ) {
$code = $myrow["kk"];
$major_name = $myrow["name"];
if ($major_field == $code ) {
$major_fields_name=$major_name;
break;
}
}
printf("Major Fields of Study: %s
\n",$major_fields_name );
$result_o=mysql_query("SELECT * FROM occupations order by kk",$db);
$occupation_name="";
while (
$myrow = mysql_fetch_array($result_o,MYSQL_ASSOC) ) {
$code = $myrow["kk"];
$o_name = $myrow["name"];
if ($occupation == $code ) {
$occupation_name=$o_name;
break;
}
}
printf("Current Occupation: %s
\n",$occupation_name );
$result_e=mysql_query("SELECT * FROM expertise order by kk",$db);
$expertise_name="";
while (
$myrow = mysql_fetch_array($result_e,MYSQL_ASSOC) ) {
$code = $myrow["kk"];
$e_name = $myrow["name"];
if ($expertise == $code ) {
$expertise_name=$e_name;
break;
}
}
printf("Expertise/Skill: %s
\n",$expertise_name );
$result_i=mysql_query("SELECT naics_code,name FROM industries ",$db);
$industries_name="";
while (
$myrow = mysql_fetch_array($result_i,MYSQL_ASSOC) ) {
$code = $myrow["naics_code"];
$i_name = $myrow["name"];
if ($industries == $code ) {
$industries_name=$i_name;
break;
}
}
printf("Familiar Industries: %s
\n",$industries_name );
printf("Hobby/Interests: %s
\n",$hobby);
printf("Profile: %s
\n",$profile);
//login page
printf("\n");
?>