";
include('db_config.php');
mysql_query("TRUNCATE TABLE tmpkap5");
mysql_query("insert into tmpkap5 (SELECT * FROM $_data
group by kd_sch,kd_code,g,s,b,a)");
if ($grp=='04') {
$sql="select *,sum(g) as g,sum(s) as s,sum(b) as b
from tmpkap5,$_act where kp_code=kd_code and kp_cd in ('04','05','06')
group by kp_code order by kp_grp,kp_code,kd_rank";
} elseif ($grp=='12') {
$sql="select *,sum(g) as g,sum(s) as s,sum(b) as b
from tmpkap5,$_act where kp_code=kd_code and kp_cd in ('12','13','14','15')
group by kp_code order by kp_grp,kp_code,kd_rank";
} else {
$sql="select *,sum(g) as g,sum(s) as s,sum(b) as b
from tmpkap5,$_act where kp_code=kd_code and kp_cd='$grp'
group by kp_code order by kp_grp,kp_code,kd_rank";
}
$result=mysql_query($sql);
echo "��ػ�����ҧ��� �¡��¡Ԩ���� $_title
";
$rw=1; $tg=0; $ts=0; $ts=0; $ta=0; $total=0;
while ($db=mysql_fetch_array($result)) {
$tt=$db[g]+$db[s]+$db[b];
$kgp=$db[kd_ceo];
echo "";
$tg+=$db[g]; $ts+=$db[s]; $tb+=$db[b]; $total+=$tt; $rw++;
}
echo "";
echo "
| ��� | ���� |
��������� | �Ԩ���� |
 |
 |
 |
��� |
| $rw |
$db[kp_code] | $db[kp_grp] |
$db[kp_act] |
$db[g] | $db[s] |
$db[b] |
$tt |
| ��� |
$tg |
$ts |
$tb |
$total |
";
?>