| ";
// Fetch all factory records
$strQuery = " SELECT * FROM research_tb rt, research_dissemination rd WHERE rt.Research_code = rd.Research_code Group By rd.academic_year_finish ";
$result1 = mysql_query($strQuery);
//Iterate through each factory
if ($result1) {
while( $rs1 = mysql_fetch_array($result1) ) {
$error_id = $rs1['id'];
$strQuery = " SELECT * FROM research_tb rt, research_dissemination rd WHERE rt.Research_code = rd.Research_code and rd.academic_year_finish='$rs1[academic_year_finish]' ";
$result2 = mysql_query($strQuery);
$numAmt = mysql_num_rows($result2);
$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);
?> |