TH;
$rk=1; $tt=0; $cl='';
while ($db=mysql_fetch_array($result)) {
$sql4="select * from $_sch where scgrp='$db[ceo_code]' group by scode";
$result4=mysql_query($sql4);
$ngp=mysql_num_rows($result4);
$sql3="select * from $_data,$_sch where kd_sch=scode and scgrp='$db[ceo_code]' group by kd_sch";
$result3=mysql_query($sql3);
$nsch=mysql_num_rows($result3);
if ($nsch==0) { $csc="-/$ngp"; } else { $csc="$nsch/$ngp"; }
$sql2="select * from $_data,$_sch,$_act where kd_code=kp_id and kd_sch=scode and scgrp='$db[ceo_code]' ";
$result2=mysql_query($sql2);
$nceo=mysql_num_rows($result2);
if ($nceo==0) { $cceo='-'; } else { $cceo=number_format($nceo); }
if ($nsch==$ngp) { $cl='#cafac5'; } else { $cl='#ffecd9'; }
if ($db[ceo_date]=='0000-00-00') { $rem=''; } else { $rem="ปิด"; }
echo <<