global $scid;
include('db_config.php');
mysql_query("TRUNCATE TABLE anb1");
mysql_query("insert into anb1 (SELECT * FROM `anb_data54`
group by kd_sch,kd_code,g,s,b,kd_sp)");
$sql="SELECT kd_code, kd_sch,sname,scode,scgrp,sum(g) AS go,sum(s) AS sv,sum(b) AS bn
FROM anb1,anb_sch54 WHERE kd_sch=scode GROUP BY scode ORDER BY go DESC,sv DESC,bn DESC";
$result=mysql_query($sql);
echo "สรุปเหรียญรางวัล (23 ม.ค.2554)";
echo "