";
include('db_config.php');
mysql_query("TRUNCATE TABLE mt1");
mysql_query("insert into mt1 (SELECT * FROM $_data
group by kd_sch,kd_code,g,s,b)");
$sql="select * from $_act where kp_cd='$grp' order by kp_code";
$result=mysql_query($sql);
echo "
สรุปเหรียญรางวัล แยกรายกิจกรรม $_title";
echo "
";
echo "
ที่
รหัส
กลุ่มสาระ
กิจกรรม
รวม
";
$rw=1; $tg=0; $ts=0; $ts=0; $ta=0; $total=0;
while ($db=mysql_fetch_array($result)) {
$sql1="select *,sum(g) as g,sum(s) as s,sum(b) as b from mt1,$_act
where kp_code=kd_code and kp_code='$db[kp_code]'
group by kp_code ";
$result1=mysql_query($sql1);
$db1=mysql_fetch_array($result1);
$tt=$db1[g]+$db1[s]+$db1[b];
if ($db1[g]==0) { $db1[g]='-'; }
if ($db1[s]==0) { $db1[s]='-'; }
if ($db1[b]==0) { $db1[b]='-'; }
echo "
