include('db_config.php');
mysql_query("TRUNCATE TABLE anb4");
mysql_query("insert into anb4 (SELECT * FROM $_data
group by kd_sch,kd_code,g,s,b,kd_sp)");
$sql="SELECT *,sum(g) AS go,sum(s) AS sv,sum(b) AS bn
FROM anb4,$_sch WHERE kd_sch=scode GROUP BY scode ORDER BY go DESC,sv DESC,bn DESC";
$result=mysql_query($sql);
echo "