";
// Fetch all factory records
$strQuery = " SELECT * FROM $myTable WHERE Budget_Year='$Budget_Year' GROUP BY Faculty_code ";
$result111 = $dbObj->execQuery($strQuery);
//Iterate through each factory
if ($result111) {
while( $rs111 = $dbObj->fetchArray($result111) ) {
$query112 = " SELECT * FROM $myTable3 WHERE Faculty_code='$rs111[Faculty_code]' ";
$result112 = $dbObj->execQuery($query112);
$rs112 = $dbObj->fetchArray($result112);
$strQuery = " SELECT * FROM $myTable WHERE Budget_Year='$rs111[Budget_Year]' AND Faculty_code='$rs111[Faculty_code]' ";
$result222 = $dbObj->execQuery($strQuery);
$numAmt = $dbObj->_numrows;
$strXML .= "";
} # while
} # if
//Finally, close element
$strXML .= "";
//Create the chart - Pie 3D Chart with data from strXML
echo renderChart("../charts/Column3D.swf", "", $strXML, "", 780, 375, false, false);
?> |