header('Content-Type: text/html; charset=tis-620');
echo "";
include('db_config.php');
mysql_query("TRUNCATE TABLE eef1");
mysql_query("insert into eef1 (SELECT * FROM eef2009_data
group by kd_sch,kd_code,g,s,b,a)");
$sql="select *,left(kp_code,2) as gr,sum(g) as g,sum(s) as s,sum(b) as b,sum(a) as a
from eef1,eef2009_act where kp_code=kd_code group by gr";
$result=mysql_query($sql);
echo "