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

".$degree_text."
Credit for RECEIVING/GRADUATING Institution

"); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); // LIST OF COLLEGES $query1 = " SELECT DISTINCT f.inst_type, f.school_abbr AS abbr, f.fice_code FROM sisdb.dbo.fice_table f WHERE f.inst_type IN ('1', '2') --AND f.fice_code = '001090' ORDER BY f.inst_type, f.school_abbr"; $result1 = odbc_exec($conn_id, $query1); $n = 1; while (odbc_fetch_row($result1)) { $inst_type = odbc_result($result1, "inst_type"); $abbr = odbc_result($result1, "abbr"); $fice_code = odbc_result($result1, "fice_code"); echo(""); echo(""); echo(""); echo(""); //echo(""); $cnt = 0; $credsum = 0; $query2 = " SELECT DISTINCT(g.ssn_id) AS ssn FROM sisdb.dbo.graduated_student_table g JOIN sisdb.dbo.student_table s ON g.ssn_id = s.ssn_id WHERE g.fice_code = '".$fice_code."' AND g.academic_year = '".$acadyr."' AND g.init_enroll_status IN ('3', '9') ".$dl_code." ".$es_code." AND s.transfer_fice IN ('001090', '001089', '001098', '001107', '001108', '001110', '001101', '001085', '001109', '001086', '001092', '012860', '001091', '901090', '011949', '020522', '022209', '009976', '012260', '023482', '012261', '012105', '030633', '020870', '001104', '020753', '021111', '020746', '007738', '005707', '020735', '005732', '005245') ; "; //echo("

".$query2."

"); $result2 = odbc_exec($conn_id, $query2); while (odbc_fetch_row($result2)) { $ssn = odbc_result($result2, 'ssn'); $cnt++; $cred = 0; $query3 = "SELECT COUNT(g.degree_level) AS cred FROM graduated_student_table g WHERE g.fice_code = '".$fice_code."' AND g.academic_year = '".$acadyr."' AND g.ssn_id = '".$ssn."' AND g.init_enroll_status IN ('3', '9');"; $result3 = odbc_exec($conn_id, $query3); while (odbc_fetch_row($result3)) { $cred = odbc_result($result3, 'cred'); } $credsum = $credsum + $cred; } echo(""); echo(""); $cnt_total = $cnt_total + $cnt; if ($inst_type == '1') { $cnt_1 = $cnt_1 + $cnt; } if ($inst_type == '2') { $cnt_2 = $cnt_2 + $cnt; } $credsum_total = $credsum_total + $credsum; if ($inst_type == '1') { $credsum_1 = $credsum_1 + $credsum; } if ($inst_type == '2') { $credsum_2 = $credsum_2 + $credsum; } echo(""); } // all totals echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo("
#ITCollegeAY".$acadyr."
GraduatesCredentials
".$n++."".$inst_type."".$abbr."".$fice_code."".number_format($cnt,0)."".number_format($credsum,0)."
4-Year Univiersities".number_format($cnt_1,0)."".number_format($credsum_1,0)."
2-Year Colleges".number_format($cnt_2,0)."".number_format($credsum_2,0)."
Total".number_format($cnt_total,0)."".number_format($credsum_total,0)."
"); odbc_error(); odbc_close($conn_id); ?>