";
include('db_config.php');
$sql="SELECT * FROM $_sch ORDER BY scgrp,scode";
$result=mysql_query($sql);
echo <<�ʹ��Ѥ�$_title
TH;
$rw=1;
while ($db=mysql_fetch_array($result)) {
$sql1="select * from $_data where kd_sch='$db[scode]' group by kd_code,kd_sch ";
$result1=mysql_query($sql1);
$act=mysql_num_rows($result1);
if ($act>0) { $cact=$act; } else { $cact='-'; }
$sql2="select * from $_data,$_act where kd_code=kp_id and kd_sch='$db[scode]' ";
$result2=mysql_query($sql2);
$std=mysql_num_rows($result2);
if ($std>0) { $cstd=$std; } else { $cstd='-'; }
$sql3="select * from $_data where kd_sch='$db[scode]' and kd_tutor<>'' ";
$result3=mysql_query($sql3);
$kru=mysql_num_rows($result3);
if ($kru>0) { $ckru=$kru; } else { $ckru='-'; }
echo <<
TB;
$rw++;
$allact+=$act;
$allstd+=$std;
$allkru+=$kru;
}
$allact=number_format($allact);
$allstd=number_format($allstd);
$allkru=number_format($allkru);
echo <<
| ��� |
�ç���¹ |
�ӹǹ |
�ѧ�Ѵ |
| �Ԩ���� |
�ѡ���¹ |
��� |
| $rw |
$db[sname] |
$cact |
$cstd |
$ckru |
$db[abb_sch] |
| ��� |
$allact |
$allstd |
$allkru |
|
TF;
?>