";
include('db_config.php');
$sql0="select scode,sname,sgrp from $_sch where scode='$scid'" ;
$result0=mysql_query($sql0);
$db0=mysql_fetch_array($result0);
$scname=$db0[sname];
$sgrp=$db0[sgrp];
$sql="SELECT * FROM $_act,$_sch,$_data
WHERE kd_code=kp_id and kd_sch=scode and kd_sch='$scid' and kd_remark='1'
order by kp_grp,kp_id";
$result=mysql_query($sql);
echo "��ػ�����ѡ���¹���᷹ CEO �ç���¹$scname ������ç���¹ $sgrp
";
$gr=''; $ac=''; $md=''; $rp=''; $rm=''; $rw1=0; $rw2=0;
while ($db=mysql_fetch_array($result)) {
if ($rw1==$rw2) {
$rw=" ";
} else {
$rw=$rw1;
}
if ($db[kd_remark]==1) {
$rem="CEO";
} else {
$rem=" ";
}
if ($db[kp_grp]==$gr) {
if ($db[kd_code] ==$ac) {
$gp=" ";
} else {
$gp="$db[kp_abb]";
}
} else {
$gp="$db[kp_abb]";
}
if ($db[kd_code] ==$ac) {
$act=" ";
} else {
$act="$db[kp_act]";
$rw1++;
$rw=$rw1;
}
echo "";
$ac=$db[kd_code]; $gr=$db[kp_grp]; $md=$medal; $rm=$db[kd_remark];
$rw2=$rw1;
}
echo "
��� |
�Ԩ���� (��ǧ���) |
��������� | ���ѡ���¹ |
���֡� |
���᷹ |
$rw |
$act |
$gp |
$db[kd_std] |
$db[kd_tutor] |
$rem |
";
?>