"; 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 ""; $tg+=$db1[g]; $ts+=$db1[s]; $tb+=$db1[b]; $total+=$tt; $rw++; } echo ""; echo "

ที่	รหัส	กลุ่มสาระ	กิจกรรม				รวม
$rw	$db[kp_code]	$db[kp_grp]	$db[kp_act]	$db1[g]	$db1[s]	$db1[b]	$tt
รวม				$tg	$ts	$tb	$total

"; ?>