header('Content-Type: text/html; charset=tis-620'); //include("../header.php"); echo ""; include('db_config.php'); $sql1="select * from $_sch where scgrp='$ceo' "; $result1=mysql_query($sql1); $db1=mysql_fetch_array($result1); $sql2="select * from $_act where kp_id='$code' "; $result2=mysql_query($sql2); $db2=mysql_fetch_array($result2); $gr=$db2[kp_cd]; $sql="select *,date_format(kd_edit,'%Y%m%d') as fdate from $_data,$_sch where kd_sch=scode and kd_code='$code' and scgrp='$ceo' order by kd_edit"; $result=mysql_query($sql); echo "
ที่ | โรงเรียน | กลุ่ม รร. | นักเรียน | ผู้ฝึกสอน | วันสมัคร |
$row | $sch | $sgrp | $ord.$db[kd_std] | $db[kd_tutor] | $tdate |
"; //include("../footer.php"); function tsdate($day) { $Tmnt=array("ม.ค.","ก.พ.","มี.ค.","เม.ย.","พ.ค.","มิ.ย.","ก.ค.", "ส.ค.","ก.ย.","ต.ค.","พ.ย.","ธ.ค.") ; return intval(substr($day,6,2))." ".$Tmnt[intval(substr($day,4,2)-1)].intval(substr($day,2,2)+43) ; } ?>