|
";
// Fetch all factory records
$strQuery = " SELECT DISTINCT(AcademicYear) FROM edu_service_tb where (M21=1 and M22=1) and (AcademicYear >='2553' and AcademicYear <='2556') Order BY AcademicYear ASC ";
$result111 = $dbObj->execQuery($strQuery);
//Iterate through each factory
if ($result111) {
while( $rs111 = $dbObj->fetchArray($result111) ) {
$sql3 = " SELECT COUNT(outreacId) AS SumB1 FROM edu_service_tb WHERE (M21=1 and M22=1) and AcademicYear ='$rs111[AcademicYear]' ";
$result3 = $dbObj->execQuery($sql3);
$rs3 = $dbObj->fetchArray($result3);
$strXML .= "";
} # while
} # if
//Finally, close element
$strXML .= "";
//Create the chart - Pie 3D Chart with data from strXML
echo renderChart("../charts/Column3D.swf", "", $strXML, "", 750, 375, false, false);
?> |
|