









 |
require('cpsafterschool/con_func.php');
$connection = o_con();
$sql = "SELECT Initiative_Name FROM Initiatives WHERE InitiativeID='$InitiativeID'";
$sth = OCIParse($connection, $sql);
$rslt = OCIExecute ($sth);
//$sql_result = mysql_query($sql) or die("Couldn't execute query. $sql");
OCIFetchInto($sth,$row,OCI_ASSOC) > 0;
$Initiative_Name = $row["INITIATIVE_NAME"];
?>
Major Initiatives
(List of Participating
Schools)
Click on a letter below for an alphabetical listing
of participating schools.
OCIFreeStatement($sth);
$sql = "SELECT SUBSTR(UPPER(School_Name),1,1) FROM Schools s, Programs p WHERE p.SchoolID = s.SchoolID AND InitiativeID='$InitiativeID' GROUP BY SUBSTR(UPPER(School_Name),1,1) ORDER BY SUBSTR(UPPER(School_Name),1,1)";
$sth = OCIParse($connection, $sql);
$rslt = OCIExecute ($sth);
//$sql_result = mysql_query($sql) or die("Couldn't execute query. $sql");
while ( OCIFetchInto($sth,$row,OCI_NUM) > 0) {
$aa = $row[0];
echo "$aa\n";
}
echo " ";
if (isset($school)) {
?>
Click on a School Name for information.
OCIFreeStatement($sth);
$sql = "SELECT distinct s.SchoolID, School_Name FROM Schools s, Programs p WHERE p.SchoolID = s.SchoolID AND InitiativeID='$InitiativeID' AND School_Name Like '$school%' ORDER BY School_Name";
echo "$school \n";
$sth = OCIParse($connection, $sql);
$rslt = OCIExecute ($sth);
//$sql_result = mysql_query($sql) or die("Couldn't execute query. $sql");
while ( OCIFetchInto($sth,$row,OCI_ASSOC) > 0) {
$School_Name = $row["SCHOOL_NAME"];
$SchoolID = $row["SCHOOLID"];
echo "$School_Name \n";
}
}
OCIFreeStatement($sth);
?>
Return to top
|
 |
 |
 |
| |
____________
ASAR
After School Attendance Reporting
To enter after
school attendance please click on this
link.
Learn more with
the "ASAR Step by Step Guide"
here.
For
questions regarding ASAR reporting, please call the ASAR
Help Line at 312-612-8229.
____________
|
|
 |
 |
 |
|