header('Content-Type: text/html; charset=tis-620');
include('../db_config.php');
$sql="select * from sk1_sch where scgrp='$sg' ";
$result=mysql_query($sql);
echo "
ที่ |
โรงเรียนส่งใบแจ้งหนี้/ใบเสร็จ |
ISP |
แนบไฟล์ |
";
$rw=1; $rp=0;
while ($db=mysql_fetch_array($result)) {
$sql2="select * from sk1_net61 where smis='$db[smis]' ";
$result2=mysql_query($sql2);
$db2=mysql_fetch_array($result2);
if (strpos($db2[snet1],'UNINET') !== false) { $unet='UniNet'; } else { $unet="$db2[isp]"; }
if ($db2[xbill]<>'') {
$rmk="";
$rp++;
$col='#dfffdf';
} else {
$rmk="";
$col='#ffe6ff';
}
echo "
$rw |
$db2[sname] |
$unet |
$rmk |
";
$rw++;
}
$tstd=number_format($rp,0,'.',',');
echo "
รวม |
$rp |
";
?>