| ";
// Fetch all factory records
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='$ReTyId' GROUP BY rt.Year_prop ";
$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_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='$ReTyId' and rt.Year_prop ='$rs1[Year_prop]' ";
$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);
?> |
| |
| No. |
ปี พ.ศ |
จำนวนผลงานวิจัย |
ทุนวิจัยภายใน |
ทุนวิจัยภายนอก |
จำนวนเงิน |
fetchArray($result) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
|
 &ReTyId=" title=" Click to more detail ">
|
execQuery($query2);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result2);
echo $countnum;
?> |
execQuery($query6);
$rs6 = $dbObj->fetchArray($result6);
$dbObj->freeresult($rs6);
echo number_format($rs6['Sum'],2,'.',',');
?> |
execQuery($query6);
$rs6 = $dbObj->fetchArray($result6);
$dbObj->freeresult($rs6);
echo number_format($rs6['Sum'],2,'.',',');
?> |
execQuery($query6);
$rs6 = $dbObj->fetchArray($result6);
$dbObj->freeresult($rs6);
echo number_format($rs6['Sum'],2,'.',',');
?> |
| ภาพรวม |
|
|
|
|
| |
|