header('Content-Type: text/html; charset=tis-620');
echo "";
global $scid;
include('db_config.php');
mysql_query("TRUNCATE TABLE tmp5sk161");
mysql_query("insert into tmp5sk161 (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
FROM tmp5sk161,$_sch WHERE kd_sch=scode
GROUP BY scode ORDER BY go DESC,sv DESC,bn DESC";
$result=mysql_query($sql);
echo "สรุปเหรียญทักษะวิชาการ สพป.ศก.1 ปี 2554";
echo "