header('Content-Type: text/html; charset=tis-620'); echo ""; include('db_config.php'); mysql_query("TRUNCATE TABLE tmpkap1"); mysql_query("insert into tmpkap1 (SELECT * FROM $_data group by kd_sch,kd_code,g,s,b)"); $sql="select *,sum(g) AS go,sum(s) AS sv,sum(b) AS bn,sum(kd_remark) as reps FROM tmpkap1,$_sch WHERE kd_sch=scode GROUP BY scode ORDER BY scgrp,go DESC,sv DESC,bn DESC,reps desc "; $result=mysql_query($sql); echo "
ที่ | โรงเรียน | 1 | 2 | 3 | รวมตัวแทน | CEO |
$row | $db[sname] | $gg | $ss | $bb | $tot | $db[abb_sch] |
รวม | $tg | $ts | $tb | $trp |