header('Content-Type: text/html; charset=tis-620');
include('../db_config.php');
//$sql="select * from sk1_sch where scgrp='$sg' ";
$sql="select * from sk1_sch where scgrp != 'prv' and scgrp='$sg' order by sname";
$result=mysql_query($sql);
echo "
ที่ |
โรงเรียน |
ส่งใบแจ้งหนี้ |
";
$rw=1;
while ($db=mysql_fetch_array($result)) {
if ($db[putil] ==1 ) {
$ast="ส่งแล้ว";
} elseif ($db[putil] =='0') {
$ast='* ไม่มี';
} elseif ($db[putil] =='' ) {
$ast='-';
}
echo "
$rw |
$db[sname] |
$ast |
";
$rw++; $tstd+=$db[ipst];
}
$tstd=number_format($tstd,0,'.',',');
echo "
รวม |
$tstd |
";
?>