"; include('db_config.php'); $sql0="select * from $_act where kp_cd='$grp'"; $result0=mysql_query($sql0); $db0=mysql_fetch_array($result0); $gp=$db0[kp_grp]; mysql_query("TRUNCATE TABLE tmpkap3"); mysql_query("insert into tmpkap3 (SELECT * FROM $_data group by kd_sch,kd_code,g,s,b)"); $sql="select *,sum(g) as g,sum(s) as s,sum(b) as b from tmpkap3,$_act where kp_id=kd_code and kp_cd='$grp' group by kp_code order by kp_id,kp_level"; $result=mysql_query($sql); echo "
สรุปเหรียญรางวัล แยกรายกิจกรรม กลุ่มสาระการเรียนรู้$gp "; echo ""; echo ""; $rw=1; $tg=0; $ts=0; $ts=0; $total=0; while ($db=mysql_fetch_array($result)) { $tt=$db[g]+$db[s]+$db[b]; $kgp=substr($db[kd_code],0,4); $sql2="select * from $_data,$_sch where kd_sch=scode and kd_code='$db[kp_id]' and kd_remark='1' order by kd_score desc"; $result2=mysql_query($sql2); $db2=mysql_fetch_array($result2); if ($result2) { $srep=$db2[sname]; $sgrp=$db2[abb_sch]; } else { $srep=""; $sgrp=""; } if ($db[g]>0) { $gg=$db[g]; } else { $gg='-'; } if ($db[s]>0) { $ss=$db[s]; } else { $ss='-'; } if ($db[b]>0) { $bb=$db[b]; } else { $bb='-'; } if ($tt>0) { $tot=$tt; } else { $tot='-'; } echo ""; $tg+=$db[g]; $ts+=$db[s]; $tb+=$db[b]; $total+=$tt; $rw++; } echo ""; echo "
ที่ กิจกรรม (คลิกดูทุก รร.ที่แข่งขัน) รวม
$rw $db[kp_act] ($db[kp_level]) $gg $ss $bb $tot
รวม $tg $ts $tb $total
"; ?>