ADHE

Progression for 4-Year Universities

".$acadyrx[0]." - ".$acadyrx[1]." - ".$acadyrx[2]." - ".$acadyrx[3]." - ".$acadyrx[4]."

"); echo("

Academic Year = ".$acadyr."

"); echo("

"); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); $queryX = "SELECT f.inst_type, f.school_abbr, f.fice_code FROM sisdb.dbo.fice_table f WHERE f.inst_type IN ('1') ORDER BY f.inst_type, f.school_abbr"; $n = 1; $resultX = mssql_query($queryX, $conn_id); $numX = mssql_num_rows($resultX); for ($a = 0; $a < $numX; $a++) { $lineX = mssql_fetch_assoc($resultX); $inst_type = $lineX['inst_type']; $school_abbr = $lineX['school_abbr']; $fice_code = $lineX['fice_code']; echo(""); echo(""); echo(""); echo(""); //echo(""); for ($i = 0; $i <= 4; $i++) { // begins for statement // cohort students $query2 = "SELECT COUNT(DISTINCT(x.ssn_id)) AS cohort FROM [sisdb].[performance].[4yrprogression] x JOIN fice_table f ON x.fice_code = f.fice_code WHERE x.fice_code = '".$fice_code."' AND x.academic_year = '".$acadyrx[$i]."' AND x.initial_cr_hrs >= 6 AND x.degree_intent IN ('2', '4', '6', '7', '8');"; echo("

".$query2."

"); $result2 = mssql_query($query2, $conn_id); $num2 = mssql_num_rows($result2); for ($b = 0; $b < $num2; $b++) { $line2 = mssql_fetch_assoc($result2); $cohort = $line2['cohort']; } echo(""); // progress students $query3 = "SELECT COUNT(DISTINCT(x.ssn_id)) AS progress FROM [sisdb].[performance].[4yrprogression] x WHERE x.fice_code = '".$fice_code."' AND x.academic_year IN ('".$acadyrx[$i]."') AND x.initial_cr_hrs >= 6 AND x.degree_intent IN ('2', '4', '6', '7', '8') AND (x.cr_hrs_in_2_years >= '18' OR x.award_in_2_years IS NOT NULL);"; //echo("

".$query3."

>hr />"); $result3 = mssql_query($query3, $conn_id); $num3 = mssql_num_rows($result3); for ($c = 0; $c < $num3; $c++) { $line3 = mssql_fetch_assoc($result3); $progress = $line3['progress']; } echo(""); $perc = ($progress * 100) / $cohort; echo(""); } //ends for statement echo(""); } echo("

#	Inst. Type	Institution	AY".$acadyr1."			AY".$acadyr2."			AY".$acadyr3."			AY".$acadyr4."			AY".$acadyr5."
#	Inst. Type	Institution	Cohort	Progress	Percent	Cohort	Progress	Percent	Cohort	Progress	Percent	Cohort	Progress	Percent	Cohort	Progress	Percent
".$n++."	".$inst_type."	".$school_abbr."	".$fice_code."	".number_format($cohort,0)."	".number_format($progress,0)."	".number_format($perc,1)."%

"); mssql_free_result($result1); mssql_close($conn_id); ?>