";
// Fetch all factory records
$strQuery = " SELECT * FROM $myTable2 WHERE Teacher_code='$Teacher_code' GROUP BY Year ";
$result111 = mysql_query($strQuery);
//Iterate through each factory
if ($result111) {
while( $rs111 = mysql_fetch_array($result111) ) {
$strQuery = " SELECT * FROM $myTable2 WHERE Teacher_code='$Teacher_code' AND Year='$rs111[Year]' ";
$result222 = mysql_query($strQuery);
$numAmt = mysql_num_rows($result222);
$strXML .= "";
} # while
} # if
//Finally, close element
$strXML .= "";
//Create the chart - Pie 3D Chart with data from strXML
echo renderChart("../charts/Pie3D.swf", "", $strXML, "", 650, 375, false, false);
?> |