header('Content-Type: text/html; charset=tis-620');
include('../db_config.php');
$sql="select * from sk1_sch62 where scgrp='$sg' ";
$result=mysql_query($sql);
echo "
ที่ |
โรงเรียน |
ส่งไฟล์ |
";
$rw=1; $nsend=0;
while ($db=mysql_fetch_array($result)) {
if ($db[final62] != '' ) {
$sql1="select sum(th_p2+th_p4+th_p5+th_m1+th_m2+ma_p2+ma_p4+ma_p5+ma_m1+ma_m2+
sc_p2+sc_p4+sc_p5+sc_m1+sc_m2+en_p2+en_p4+en_p5+en_m1+en_m2) as nkey
from sk1_final_62 where scode='$db[scode]' ";
$result1=mysql_query($sql1);
$db1=mysql_fetch_array($result1);
$nkey=$db1[nkey];
$ast='';
$nsend++;
} else {
$ast='';
$nkey='';
}
echo "
$rw |
$db[sname] |
$ast $nkey |
";
$rw++;
}
$tstd=number_format($tstd,0,'.',',');
echo "
รวม |
$nsend |
";
/*
ลบข้อมูลเดิม
update sk1_final_62 set th_p2='',th_p4='',th_p5='',
th_m1='',th_m2='',ma_p2='',ma_p4='',
ma_p5='',ma_m1='',ma_m2='',sc_p2='',
sc_p4='',sc_p5='',sc_m1='',sc_m2='',
en_p2='',en_p4='',en_p5='',en_m1='',en_m2=''
*/
?>