";
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 ";
*/
mysql_query("TRUNCATE TABLE tmp4sk162");
mysql_query("insert into tmp4sk162 (SELECT * FROM $_data group by kd_sch,kd_code,kd_remark)");
$sql="SELECT *,sum(kd_remark) as rmk
FROM tmp4sk162,$_sch WHERE kd_sch=scode
GROUP BY scode ORDER BY scgrp,scode";
$result=mysql_query($sql);
echo "
สรุป$_title
ที่
โรงเรียน
รวมตัวแทน
CEO
";
$row=1; $tg=0; $ts=0; $tb=0; $tt=0; $trp=0;
while ($db=mysql_fetch_array($result)) {
if ($db[rmk]>0) { $rr="$db[rmk]"; } else { $rr='-'; }
if ($total>0) { $tot=$total; } else { $tot='-'; }
echo "