header('Content-Type: text/html; charset=tis-620'); echo ""; 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)"); //if ($grp=='04') { $kg="kp_cd in ('04','05','06')"; } else { $kg="kp_cd like '$grp%' "; } if ($grp=='04') { $kg="kp_cd in ('04','05','06')"; } elseif ($grp=='12') { $kg="kp_cd in ('12','13','14','15')"; } else { $kg="kp_cd like '$grp%' "; } $sql="select * from $_act where $kg order by kp_code"; $result=mysql_query($sql); echo "
ที่ | รหัส | กลุ่มสาระ | กิจกรรม | รวม | |||
$rw | $db[kp_code] | $db[kp_grp] | $db[kp_act] | $db1[g] | $db1[s] | $db1[b] | $tt |
รวม | $tg | $ts | $tb | $total |