execQuery($query); $numrows = $dbObj->_numrows; /** Paging */ $display = ( !isset ($_GET['page']) ) ? 1 : $_GET['page']; $start = ( ($display * $limit) - $limit ); /** Paging */ if( isset($_GET['OrderBy']) ) { $query = " SELECT * FROM $myTable WHERE FacultyStatus ='Y' ORDER BY $OrderBy $ASCDESC "; } elseif( !isset($_GET['OrderBy']) ) { $query = " SELECT * FROM $myTable WHERE FacultyStatus ='Y' ORDER BY $myTableFK ASC "; } $query .= " LIMIT $start, $limit "; $result = $dbObj->execQuery($query); ?> หน้าหลัก » ข้อมูลสรุปสถานะบุคลากร » รายชื่อภาค/ฝ่าย   ‹ ย้อนกลับ     "; // Fetch all factory records $strQuery = " SELECT * FROM $myTable1 GROUP BY Faculty_code "; $result111 = $dbObj->execQuery($strQuery); //Iterate through each factory if ($result111) { while( $rs111 = $dbObj->fetchArray($result111) ) { $query112 = " SELECT * FROM $myTable WHERE Faculty_code='$rs111[Faculty_code]' "; $result112 = $dbObj->execQuery($query112); $rs112 = $dbObj->fetchArray($result112); $strQuery3 = " SELECT * FROM $myTable1 WHERE StatusId='1' AND Faculty_code='$rs111[Faculty_code]' "; $result3 = $dbObj->execQuery($strQuery3); $numAmt3 = $dbObj->_numrows; $dbObj->freeresult($result3); $strXML .= ""; } # while } # if //Finally, close element $strXML .= ""; //Create the chart - Pie 3D Chart with data from strXML echo renderChart("./charts/Pie3D.swf", "", $strXML, "", 700, 375, false, false); ?>

freeresult($result); /** Close the Database */ $dbObj->disconn(); /** Unset Class */ unset($dbObj); ?>