= '".dmyE2ymdT($_REQUEST['dateStart'])."' AND formaoffice.Date_finish <= '".dmyE2ymdT($_REQUEST['dateFinish'])."' "; $query = " SELECT *, prefixName as First_name FROM formaoffice LEFT JOIN personal_tb ON formaoffice.Teacher_code = personal_tb.Teacher_code LEFT JOIN prefix ON personal_tb.First_name = prefix.prefixId WHERE formaoffice.Date_start >= '".dmyE2ymdT($_REQUEST['dateStart'])."' AND formaoffice.Date_finish <= '".dmyE2ymdT($_REQUEST['dateFinish'])."' "; $result = $dbObj->execQuery($query); ?>
¢éÍÁÙÅ¡ÒÃä»ÃÒª¡Òà µÑé§áµèÇѹ·Õè =($_REQUEST['dateStart'])?dmyE2dmyT($_REQUEST['dateStart']):dmyE2dmyT(date("d/m/Y"));?> ¶Ö§Çѹ·Õè =($_REQUEST['dateFinish'])?dmyE2dmyT($_REQUEST['dateFinish']):dmyE2dmyT(date("d/m/Y"));?> | |||
No | ª×èÍ | àÃ×èͧ | ÃÐËÇèÒ§Çѹ·Õè |
=$no;?> | - |