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