header('Content-Type: text/html; charset=tis-620');
include('../db_config.php');
$sql="select *,count(*) as nsc from sk1_sch where scgrp != 'prv' group by scgrp order by sampur";
$result=mysql_query($sql);
echo "
·Õè |
¡ÅØèÁ âçàÃÕ¹ |
·Ñé§ ËÁ´ |
˹Õé¤èÒ ä¿¿éÒ |
¹éÓ-ä¿ à¹çµ |
«èÍÁ ÍÒ¤Òà |
ÃéÍÂÅÐ |
";
$rw=1; $gsce=$gsci=$gscb=0; $sc=0;
while ($db=mysql_fetch_array($result)) {
$sql2="select * from sk1_sch where scgrp='$db[scgrp]' ";
$result2=mysql_query($sql2);
while ($db2=mysql_fetch_array($result2)) {
if ($db2[fixe]!='') { $gsce++; }
if ($db2[fixn]!='') { $gsci++; }
if ($db2[fixb]!='') { $gscb++; }
if (($gsce+$gsci+$gscb)>0) { $sc=1; }
}
if ($gsce>0 ) { $gge=$gsce; } else { $gge='-';}
if ($gsci>0 ) { $ggi=$gsci; } else { $ggi='-';}
if ($gscb>0 ) { $ggb=$gscb; } else { $ggb='-';}
$perc=number_format($sc*100/$db[nsc],2,'.','');
echo "
$rw |
$db[sgrp] |
$db[nsc] |
$gge |
$ggi |
$ggb |
$perc |
";
$rw++;
$tgsce+=$gsce;
$tgsci+=$gsci;
$tgscb+=$gscb;
$gsce=$gsci=$gscb=0;
$tsc+=$sc;
$sc=0;
$tnsc+=$db[nsc];
}
$tperc=number_format($tsc*100/$tnsc,2,'.','');
echo "
ÃÇÁ |
$tnsc |
$tgsce |
$tgsci |
$tgscb |
$tperc |
";
?>