header('Content-Type: text/html; charset=tis-620');
include('../db_config.php');
$sql="select * from sk1_net a,sk1_sch b where a.smis=b.smis and scgrp='$sg' ";
$result=mysql_query($sql);
echo "
ที่ |
โรงเรียน |
WiFi |
Tab |
IPs |
Uni |
แจ้ง |
";
$rw=1;
while ($db=mysql_fetch_array($result)) {
if ($db[ap_f] !='') {
if ($db[ap_f]==1) { $ap='/'; } else { $ap='X'; }
} else { $ap=''; }
if ($db[fw_f] !='') {
if ($db[fw_f]==1) { $fw='/'; } else { $fw='X'; }
} else { $fw=''; }
if ($db[sat_f] !='') {
if ($db[sat_f]==1) { $sat='/'; } else { $sat='X'; }
} else { $sat=''; }
if ($db[unet_f] !='') {
if ($db[unet_f]==1) { $unet='/'; } else { $unet='X'; }
} else { $unet=''; }
if ($db[req] != '' ) { $req='แจ้ง'; } else { $req=''; }
if ($db[updata] != '0000-00-00 00:00:00') { $col='#ccffcc'; } else { $col=''; }
echo "
$rw |
$db[sname] |
$ap |
$fw |
$sat |
$unet |
$req |
";
$rw++;
}
$tstd=number_format($tstd,0,'.',',');
echo "
รวม |
|
[ กลับ ]";
?>