".$Credentials.""); echo("

Academic Year = ".$acadyr." Degree Level = ".$degree_text."

"); // use old race codes if ($acadyr <= '2009') { $query1 = " SELECT DISTINCT f.inst_type, f.fice_code, f.school_abbr FROM fice_table f WHERE f.inst_type IN ('1', '2') --OR f.fice_code IN ('031052', '016498')) AND f.fice_code <> '010311' ORDER BY f.inst_type, f.school_abbr"; $result1 = odbc_exec($conn_id, $query1); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); // Numbers echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); $n = 1; while (odbc_fetch_row($result1)) { echo(""); echo(""); echo(""); $fice_code = (odbc_result($result1, "fice_code")); echo(""); // TOTAL COUNT OF ALL STUDENTS $cnt = 0; $asian = 0; $black = 0; $hispanic = 0; $amerind = 0; $white = 0; $nra = 0; $unknown = 0; $minority = 0; $queryX = "SELECT COUNT(".$distinct."(g.ssn_id)) AS cnt, COUNT(".$distinct."(CASE g.race WHEN 01 THEN g.ssn_id ELSE NULL END)) AS asian, COUNT(".$distinct."(CASE g.race WHEN 02 THEN g.ssn_id ELSE NULL END)) AS black, COUNT(".$distinct."(CASE g.race WHEN 03 THEN g.ssn_id ELSE NULL END)) AS hispanic, COUNT(".$distinct."(CASE g.race WHEN 04 THEN g.ssn_id ELSE NULL END)) AS amerind, COUNT(".$distinct."(CASE g.race WHEN 05 THEN g.ssn_id ELSE NULL END)) AS white, COUNT(".$distinct."(CASE g.race WHEN 06 THEN g.ssn_id ELSE NULL END)) AS nra, COUNT(".$distinct."(CASE g.race WHEN 09 THEN g.ssn_id ELSE NULL END)) AS unknown FROM graduated_student_table g WHERE g.fice_code = '".$fice_code."' ".$dl_code." AND g.academic_year = '".$acadyr."' "; //echo($queryX."
"); $resultX = odbc_exec($conn_id, $queryX); while (odbc_fetch_row($resultX)) { $cnt = odbc_result($resultX, "cnt"); $asian = odbc_result($resultX, "asian"); $black = odbc_result($resultX, "black"); $hispanic = odbc_result($resultX, "hispanic"); $amerind = odbc_result($resultX, "amerind"); $white = odbc_result($resultX, "white"); $nra = odbc_result($resultX, "nra"); $unknown = odbc_result($resultX, "unknown"); } echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); $minority = $asian + $black + $hispanic + $amerind; echo(""); $asian_total = $asian_total + $asian; if ($inst_type == '1') { $asian_1 = $asian_1 + $asian; } if ($inst_type == '2') { $asian_2 = $asian_2 + $asian; } if ($inst_type == 'P') { $asian_P = $asian_P + $asian; } if ($inst_type == 'V') { $asian_V = $asian_V + $asian; } $black_total = $black_total + $black; if ($inst_type == '1') { $black_1 = $black_1 + $black; } if ($inst_type == '2') { $black_2 = $black_2 + $black; } if ($inst_type == 'P') { $black_P = $black_P + $black; } if ($inst_type == 'V') { $black_V = $black_V + $black; } $hispanic_total = $hispanic_total + $hispanic; if ($inst_type == '1') { $hispanic_1 = $hispanic_1 + $hispanic; } if ($inst_type == '2') { $hispanic_2 = $hispanic_2 + $hispanic; } if ($inst_type == 'P') { $hispanic_P = $hispanic_P + $hispanic; } if ($inst_type == 'V') { $hispanic_V = $hispanic_V + $hispanic; } $amerind_total = $amerind_total + $amerind; if ($inst_type == '1') { $amerind_1 = $amerind_1 + $amerind; } if ($inst_type == '2') { $amerind_2 = $amerind_2 + $amerind; } if ($inst_type == 'P') { $amerind_P = $amerind_P + $amerind; } if ($inst_type == 'V') { $amerind_V = $amerind_V + $amerind; } $white_total = $white_total + $white; if ($inst_type == '1') { $white_1 = $white_1 + $white; } if ($inst_type == '2') { $white_2 = $white_2 + $white; } if ($inst_type == 'P') { $white_P = $white_P + $white; } if ($inst_type == 'V') { $white_V = $white_V + $white; } $nra_total = $nra_total + $nra; if ($inst_type == '1') { $nra_1 = $nra_1 + $nra; } if ($inst_type == '2') { $nra_2 = $nra_2 + $nra; } if ($inst_type == 'P') { $nra_P = $nra_P + $nra; } if ($inst_type == 'V') { $nra_V = $nra_V + $nra; } $unknown_total = $unknown_total + $unknown; if ($inst_type == '1') { $unknown_1 = $unknown_1 + $unknown; } if ($inst_type == '2') { $unknown_2 = $unknown_2 + $unknown; } if ($inst_type == 'P') { $unknown_P = $unknown_P + $unknown; } if ($inst_type == 'V') { $unknown_V = $unknown_V + $unknown; } $cnt_total = $cnt_total + $cnt; if ($inst_type == '1') { $cnt_1 = $cnt_1 + $cnt; } if ($inst_type == '2') { $cnt_2 = $cnt_2 + $cnt; } if ($inst_type == 'P') { $cnt_P = $cnt_P + $cnt; } if ($inst_type == 'V') { $cnt_V = $cnt_V + $cnt; } $minority_total = $minority_total + $minority; if ($inst_type == '1') { $minority_1 = $minority_1 + $minority; } if ($inst_type == '2') { $minority_2 = $minority_2 + $minority; } if ($inst_type == 'P') { $minority_P = $minority_P + $minority; } if ($inst_type == 'V') { $minority_V = $minority_V + $minority; } echo(""); } // SUMMARY echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); // TOTALS FOR 2-YEAR COLLEGES echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); // TOTALS FOR PRIVATES /*echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); */ // TOTALS FOR BSN AND JSN /*echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); */ // TOTALS FOR ALL echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo("
Academic Year ".$acadyr." Unduplicated Graduates by Race/Ethnicity
#Inst.
Type
School
Abbrev.
AsianBlackHispanicAm. Indian or AlaskanWhiteNon-Resident AlienUnknownTotalTotal Minorities
"); echo($n++); echo(""); $inst_type = (odbc_result($result1, "inst_type")); echo($inst_type); echo(""); echo(odbc_result($result1, "school_abbr")); echo("".number_format($asian,0)."".number_format($black,0)."".number_format($hispanic,0)."".number_format($amerind,0)."".number_format($white,0)."".number_format($nra,0)."".number_format($unknown,0)."".number_format($cnt,0)."".number_format($minority,0)."
4-Year Universities (1)".number_format($asian_1,0)."".number_format($black_1,0)."".number_format($hispanic_1,0)."".number_format($amerind_1,0)."".number_format($white_1,0)."".number_format($nra_1,0)."".number_format($unknown_1,0)."".number_format($cnt_1,0)."".number_format($minority_1,0)."
2-Year Colleges (2)".number_format($asian_2,0)."".number_format($black_2,0)."".number_format($hispanic_2,0)."".number_format($amerind_2,0)."".number_format($white_2,0)."".number_format($nra_2,0)."".number_format($unknown_2,0)."".number_format($cnt_2,0)."".number_format($minority_2,0)."
Private Institutions (P)".number_format($asian_P,0)."".number_format($black_P,0)."".number_format($hispanic_P,0)."".number_format($amerind_P,0)."".number_format($white_P,0)."".number_format($nra_P,0)."".number_format($unknown_P,0)."".number_format($cnt_P,0)."".number_format($minority_P,0)."
Vocational Institutions (V)".number_format($asian_V,0)."".number_format($black_V,0)."".number_format($hispanic_V,0)."".number_format($amerind_V,0)."".number_format($white_V,0)."".number_format($nra_V,0)."".number_format($unknown_V,0)."".number_format($cnt_V,0)."".number_format($minority_V,0)."
Totals".number_format($asian_total,0)."".number_format($black_total,0)."".number_format($hispanic_total,0)."".number_format($amerind_total,0)."".number_format($white_total,0)."".number_format($nra_total,0)."".number_format($unknown_total,0)."".number_format($cnt_total,0)."".number_format($minority_total,0)."
"); // ends if statement for if ($acadyr <= '2009') } // starts new if statement - years >= 2010 if ($acadyr >= '2010') { $query1 = " SELECT DISTINCT f.inst_type, f.fice_code, f.school_abbr FROM fice_table f WHERE f.inst_type IN ('1', '2') --OR f.fice_code IN ('031052', '016498')) AND f.fice_code <> '010311' ORDER BY f.inst_type, f.school_abbr"; $result1 = odbc_exec($conn_id, $query1); echo(""); echo(""); echo(""); echo(""); echo(""); // Numbers echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); $n = 1; while (odbc_fetch_row($result1)) { echo(""); echo(""); echo(""); $fice_code = (odbc_result($result1, "fice_code")); echo(""); // asian $asian = 0; $query_asian = "SELECT COUNT(".$distinct."(g.ssn_id)) AS asian FROM graduated_student_table g WHERE g.fice_code = '".$fice_code."' AND g.academic_year = '".$acadyr."' AND g.non_resident_alien = '0' AND g.asian = '1' AND g.black IN ('0', '2') AND g.hispanic IN ('0', '2') AND g.amerind IN ('0', '2') AND g.white IN ('0', '2') AND g.hawaiian IN ('0', '2') ".$dl_code." "; $result_asian = odbc_exec($conn_id, $query_asian); while (odbc_fetch_row($result_asian)) { $asian = (odbc_result($result_asian, "asian")); } echo(""); // black $black = 0; $query_black = "SELECT COUNT(".$distinct."(g.ssn_id)) AS black FROM graduated_student_table g WHERE g.fice_code = '".$fice_code."' AND g.academic_year = '".$acadyr."' AND g.non_resident_alien = '0' AND g.black = '1' AND g.asian IN ('0', '2') AND g.hispanic IN ('0', '2') AND g.amerind IN ('0', '2') AND g.white IN ('0', '2') AND g.hawaiian IN ('0', '2') ".$dl_code." "; $result_black = odbc_exec($conn_id, $query_black); while (odbc_fetch_row($result_black)) { $black = (odbc_result($result_black, "black")); } echo(""); // hispanic $hispanic = 0; $query_hispanic = " SELECT COUNT(".$distinct."(g.ssn_id)) AS hispanic FROM graduated_student_table g WHERE g.fice_code = '".$fice_code."' AND g.academic_year = '".$acadyr."' AND g.non_resident_alien = '0' AND g.hispanic = '1' ".$dl_code." "; $result_hispanic = odbc_exec($conn_id, $query_hispanic); while (odbc_fetch_row($result_hispanic)) { $hispanic = (odbc_result($result_hispanic, "hispanic")); } echo(""); // amerind $amerind = 0; $query_amerind = " SELECT COUNT(".$distinct."(g.ssn_id)) AS amerind FROM graduated_student_table g WHERE g.fice_code = '".$fice_code."' AND g.academic_year = '".$acadyr."' AND g.non_resident_alien = '0' AND g.amerind = '1' AND g.asian IN ('0', '2') AND g.hispanic IN ('0', '2') AND g.black IN ('0', '2') AND g.white IN ('0', '2') AND g.hawaiian IN ('0', '2') ".$dl_code." "; $result_amerind = odbc_exec($conn_id, $query_amerind); while (odbc_fetch_row($result_amerind)) { $amerind = (odbc_result($result_amerind, "amerind")); } echo(""); // white $white = 0; $query_white = "SELECT COUNT(".$distinct."(g.ssn_id)) AS white FROM graduated_student_table g WHERE g.fice_code = '".$fice_code."' AND g.academic_year = '".$acadyr."' AND g.non_resident_alien = '0' AND g.white = '1' AND g.asian IN ('0', '2') AND g.hispanic IN ('0', '2') AND g.black IN ('0', '2') AND g.amerind IN ('0', '2') AND g.hawaiian IN ('0', '2') ".$dl_code." "; $result_white = odbc_exec($conn_id, $query_white); while (odbc_fetch_row($result_white)) { $white = (odbc_result($result_white, "white")); } echo(""); // hawaiian $hawaiian = 0; $query_hawaiian = " SELECT COUNT(".$distinct."(g.ssn_id)) AS hawaiian FROM graduated_student_table g WHERE g.fice_code = '".$fice_code."' AND g.academic_year = '".$acadyr."' AND g.non_resident_alien = '0' AND g.hawaiian = '1' AND g.asian IN ('0', '2') AND g.hispanic IN ('0', '2') AND g.black IN ('0', '2') AND g.amerind IN ('0', '2') AND g.white IN ('0', '2') ".$dl_code." "; $result_hawaiian = odbc_exec($conn_id, $query_hawaiian); while (odbc_fetch_row($result_hawaiian)) { $hawaiian = (odbc_result($result_hawaiian, "hawaiian")); } echo(""); // two or more races $multi = 0; $query_multi = "SELECT COUNT(".$distinct."(g.ssn_id)) AS multi FROM graduated_student_table g WHERE g.fice_code = '".$fice_code."' AND g.academic_year = '".$acadyr."' ".$dl_code." AND ( g.non_resident_alien = '0' AND g.asian = '1' AND g.black = '1' AND g.hispanic IN ('0', '2') OR (g.non_resident_alien = '0' AND g.asian = '1' AND g.amerind = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.asian = '1' AND g.white = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.asian = '1' AND g.hawaiian = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.black = '1' AND g.amerind = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.black = '1' AND g.white = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.black = '1' AND g.hawaiian = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.amerind = '1' AND g.white = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.amerind = '1' AND g.hawaiian = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.white = '1' AND g.hawaiian = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.asian = '1' AND g.black = '1' AND g.amerind = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.asian = '1' AND g.black = '1' AND g.hawaiian = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.asian = '1' AND g.black = '1' AND g.white = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.asian = '1' AND g.amerind = '1' AND g.white = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.asian = '1' AND g.amerind = '1' AND g.hawaiian = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.asian = '1' AND g.white = '1' AND g.hawaiian = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.black = '1' AND g.amerind = '1' AND g.white = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.black = '1' AND g.amerind = '1' AND g.hawaiian = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.black = '1' AND g.white = '1' AND g.hawaiian = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.amerind = '1' AND g.white = '1' AND g.hawaiian = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.asian = '1' AND g.black = '1' AND g.amerind = '1' AND g.white = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.asian = '1' AND g.black = '1' AND g.amerind = '1' AND g.hawaiian = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.asian = '1' AND g.black = '1' AND g.white = '1' AND g.hawaiian = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.asian = '1' AND g.amerind = '1' AND g.white = '1' AND g.hawaiian = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.black = '1' AND g.amerind = '1' AND g.white = '1' AND g.hawaiian = '1' AND g.hispanic IN ('0', '2')) OR (g.non_resident_alien = '0' AND g.asian = '1' AND g.black = '1' AND g.amerind = '1' AND g.white = '1' AND g.hawaiian = '1' AND g.hispanic IN ('0', '2')) ) ;"; //echo("

".$query_multi."


"); $result_multi = odbc_exec($conn_id, $query_multi); while (odbc_fetch_row($result_multi)) { $multi = odbc_result($result_multi, "multi"); } echo(""); // non-resident aliens $nra = 0; $query_nra = " SELECT COUNT(".$distinct."(g.ssn_id)) AS nra FROM graduated_student_table g WHERE g.fice_code = '".$fice_code."' AND g.academic_year = '".$acadyr."' AND g.non_resident_alien = '6' ".$dl_code." "; $result_nra = odbc_exec($conn_id, $query_nra); while (odbc_fetch_row($result_nra)) { $nra = (odbc_result($result_nra, "nra")); } echo(""); // unknown $uk = 0; $query_uk = " SELECT COUNT(".$distinct."(g.ssn_id)) AS uk FROM graduated_student_table g WHERE g.fice_code = '".$fice_code."' AND g.academic_year = '".$acadyr."' ".$dl_code." AND ( g.non_resident_alien IN ('09', '9') OR (g.non_resident_alien = '00' AND g.asian IN ('0', '2') AND g.black IN ('0', '2') AND g.hispanic IN ('0', '2') AND g.amerind IN ('0', '2') AND g.white IN ('0', '2') AND g.hawaiian IN ('0', '2')) );"; //echo("

".$query_uk."

"); $result_uk = odbc_exec($conn_id, $query_uk); while (odbc_fetch_row($result_uk)) { $uk = odbc_result($result_uk, "uk"); } echo(""); // TOTAL COUNT OF ALL STUDENTS $cnt = 0; $queryX = " SELECT COUNT(".$distinct."(g.ssn_id)) AS cnt FROM graduated_student_table g WHERE g.fice_code = '".$fice_code."' AND g.academic_year = '".$acadyr."' ".$dl_code." "; $resultX = odbc_exec($conn_id, $queryX); while (odbc_fetch_row($resultX)) { $cnt = (odbc_result($resultX, "cnt")); } $minority = 0; $minority = $asian + $black + $hispanic + $amerind + $hawaiian + $multi; echo(""); echo(""); // TOTAL CALCS if ($inst_type == '1') { $total_1_asian = $total_1_asian + $asian; $total_1_black = $total_1_black + $black; $total_1_hispanic = $total_1_hispanic + $hispanic; $total_1_amerind = $total_1_amerind + $amerind; $total_1_white = $total_1_white + $white; $total_1_hawaiian = $total_1_hawaiian + $hawaiian; $total_1_multi = $total_1_multi + $multi; $total_1_nra = $total_1_nra + $nra; $total_1_other = $total_1_other + $other; $total_1_uk = $total_1_uk + $uk; $total_1_cnt = $total_1_cnt + $cnt; $total_1_minority = $total_1_minority + $minority; } if ($inst_type == '2') { $total_2_asian = $total_2_asian + $asian; $total_2_black = $total_2_black + $black; $total_2_hispanic = $total_2_hispanic + $hispanic; $total_2_amerind = $total_2_amerind + $amerind; $total_2_white = $total_2_white + $white; $total_2_hawaiian = $total_2_hawaiian + $hawaiian; $total_2_multi = $total_2_multi + $multi; $total_2_nra = $total_2_nra + $nra; $total_2_other = $total_2_other + $other; $total_2_uk = $total_2_uk + $uk; $total_2_cnt = $total_2_cnt + $cnt; $total_2_minority = $total_2_minority + $minority; } if ($inst_type == 'P') { $total_P_asian = $total_P_asian + $asian; $total_P_black = $total_P_black + $black; $total_P_hispanic = $total_P_hispanic + $hispanic; $total_P_amerind = $total_P_amerind + $amerind; $total_P_white = $total_P_white + $white; $total_P_hawaiian = $total_P_hawaiian + $hawaiian; $total_P_multi = $total_P_multi + $multi; $total_P_nra = $total_P_nra + $nra; $total_P_other = $total_P_other + $other; $total_P_uk = $total_P_uk + $uk; $total_P_cnt = $total_P_cnt + $cnt; $total_P_minority = $total_P_minority + $minority; } if ($inst_type == 'V') { $total_V_asian = $total_V_asian + $asian; $total_V_black = $total_V_black + $black; $total_V_hispanic = $total_V_hispanic + $hispanic; $total_V_amerind = $total_V_amerind + $amerind; $total_V_white = $total_V_white + $white; $total_V_hawaiian = $total_V_hawaiian + $hawaiian; $total_V_multi = $total_V_multi + $multi; $total_V_nra = $total_V_nra + $nra; $total_V_other = $total_V_other + $other; $total_V_uk = $total_V_uk + $uk; $total_V_cnt = $total_V_cnt + $cnt; $total_V_minority = $total_V_minority + $minority; } $TOTALASIAN = $total_1_asian + $total_2_asian + $total_P_asian + $total_V_asian; $TOTALBLACK = $total_1_black + $total_2_black + $total_P_black + $total_V_black; $TOTALHISPANIC = $total_1_hispanic + $total_2_hispanic + $total_P_hispanic + $total_V_hispanic; $TOTALAMERIND = $total_1_amerind + $total_2_amerind + $total_P_amerind + $total_V_amerind; $TOTALWHITE = $total_1_white + $total_2_white + $total_P_white + $total_V_white; $TOTALHAWAIIAN = $total_1_hawaiian + $total_2_hawaiian + $total_P_hawaiian + $total_V_hawaiian; $TOTALMULTI = $total_1_multi + $total_2_multi + $total_P_multi + $total_V_multi; $TOTALNRA = $total_1_nra + $total_2_nra + $total_P_nra + $total_V_nra; $TOTALUK = $total_1_uk + $total_2_uk + $total_P_uk + $total_V_uk; $TOTALOTHER = $total_1_other + $total_2_other + $total_P_other + $total_V_other; $TOTALCNT = $total_1_cnt + $total_2_cnt + $total_P_cnt + $total_V_cnt; $TOTALMINORITY = $total_1_minority + $total_2_minority + $total_P_minority + $total_V_minority; //$GRANDTOTAL = $total_1 + $total_2 + $total_P; echo(""); } // SUMMARY // TOTALS FOR 4-YEAR COLLEGES - NUMBERS echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); // SUMMARY // TOTALS FOR 2-YEAR COLLEGES - NUMBERS echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); // SUMMARY // TOTALS FOR PRIVATE - NUMBERS /*echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); */ // SUMMARY // TOTALS FOR VOCATIONAL - BSN AND JSN ONLY - NUMBERS /*echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); */ // GRAND TOTALS echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo("
#Inst.
Type
School
Abbrev.
Asian OnlyBlack OnlyHispanic AnyAm. Indian or Alaskan OnlyWhite OnlyHawaiian OnlyTwo or More RacesNon-Resident AlienUnknownTotalTotal Minorities
"); echo($n++); echo(""); $inst_type = (odbc_result($result1, "inst_type")); echo($inst_type); echo(""); echo(odbc_result($result1, "school_abbr")); echo("".number_format($asian,0)."".number_format($black,0)."".number_format($hispanic,0)."".number_format($amerind,0)."".number_format($white,0)."".number_format($hawaiian,0)."".number_format($multi,0)."".number_format($nra,0)."".number_format($uk,0)."".number_format($cnt,0)."".number_format($minority,0)."
4-Year Universities".number_format($total_1_asian,0)."".number_format($total_1_black,0)."".number_format($total_1_hispanic,0)."".number_format($total_1_amerind,0)."".number_format($total_1_white,0)."".number_format($total_1_hawaiian,0)."".number_format($total_1_multi,0)."".number_format($total_1_nra,0)."".number_format($total_1_uk,0)."".number_format($total_1_cnt,0)."".number_format($total_1_minority,0)."
2-Year Colleges".number_format($total_2_asian,0)."".number_format($total_2_black,0)."".number_format($total_2_hispanic,0)."".number_format($total_2_amerind,0)."".number_format($total_2_white,0)."".number_format($total_2_hawaiian,0)."".number_format($total_2_multi,0)."".number_format($total_2_nra,0)."".number_format($total_2_uk,0)."".number_format($total_2_cnt,0)."".number_format($total_2_minority,0)."
Private Institutions".number_format($total_P_asian,0)."".number_format($total_P_black,0)."".number_format($total_P_hispanic,0)."".number_format($total_P_amerind,0)."".number_format($total_P_white,0)."".number_format($total_P_hawaiian,0)."".number_format($total_P_multi,0)."".number_format($total_P_nra,0)."".number_format($total_P_uk,0)."".number_format($total_P_cnt,0)."".number_format($total_P_minority,0)."
Vocational (Nursing) Schools".number_format($total_V_asian,0)."".number_format($total_V_black,0)."".number_format($total_V_hispanic,0)."".number_format($total_V_amerind,0)."".number_format($total_V_white,0)."".number_format($total_V_hawaiian,0)."".number_format($total_V_multi,0)."".number_format($total_V_nra,0)."".number_format($total_V_uk,0)."".number_format($total_V_cnt,0)."".number_format($total_V_minority,0)."
Totals".number_format($TOTALASIAN,0)."".number_format($TOTALBLACK,0)."".number_format($TOTALHISPANIC,0)."".number_format($TOTALAMERIND,0)."".number_format($TOTALWHITE,0)."".number_format($TOTALHAWAIIAN,0)."".number_format($TOTALMULTI,0)."".number_format($TOTALNRA,0)."".number_format($TOTALUK,0)."".number_format($TOTALCNT,0)."".number_format($TOTALMINORITY,0)."
"); // ends if statement for if ($acadyr >= '2010') } odbc_free_result($result1); odbc_free_result($result2); odbc_free_result($result3); odbc_free_result($result4); odbc_free_result($result5); odbc_free_result($result6); odbc_free_result($result7); odbc_free_result($result8); odbc_free_result($resultX); odbc_free_result($resultx); odbc_error(); odbc_close($conn_id); ?>