= '".dmyE2ymdT($_REQUEST['dateStart'])."' AND history_absent_tb.Date_finish <= '".dmyE2ymdT($_REQUEST['dateFinish'])."' "; $query = " SELECT *, prefixName as First_name FROM history_absent_tb LEFT JOIN personal_tb ON history_absent_tb.Teacher_code = personal_tb.Teacher_code LEFT JOIN prefix ON personal_tb.First_name = prefix.prefixId WHERE history_absent_tb.Date_start >= '".dmyE2ymdT($_REQUEST['dateStart'])."' AND history_absent_tb.Date_finish <= '".dmyE2ymdT($_REQUEST['dateFinish'])."' "; $result = $dbObj->execQuery($query); ?> fetchArray($result) ) { $bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF"; ?>

¢éÍÁÙÅ¡ÒÃÅÒ µÑé§áµèÇѹ·Õè ¶Ö§Çѹ·Õè
No	ª×èÍ	àÃ×èͧ	ÃÐËÇèÒ§Çѹ·Õè	¨Ó¹Ç¹Çѹ·ÕèÅÒ
		execQuery($query); $rs2 = $dbObj->fetchArray($result2); $dbObj->freeresult($result1); echo " $rs2[Absent_type] "; ?>	-	execQuery($query); // $rs3 = $dbObj->fetchArray($result3); // $dbObj->freeresult($result3); echo " $rs[Absent_times] "; ?>

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