"); $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"); printf("\n", $id); printf("\n"); printf("
\n"); printf("
\n"); ?>