|
|
|
โครงการที่รองรับตัวบ่งชี้ |
|
|
|
$strSQL2 = "SELECT idc.head_indicator, idc.name_indicator, idc.id_indicator, (
SELECT COUNT( id_project )
FROM project
WHERE descriptor = idc.id_indicator or descriptor2 = idc.id_indicator or descriptor3 = idc.id_indicator or descriptor4 = idc.id_indicator or descriptor5 = idc.id_indicator
) AS cou
FROM indicator AS idc
GROUP BY idc.id_indicator";
$objQuery2 = mysql_query($strSQL2) or die ("Error Query [".$strSQL2."]");
$objQuery2 = mysql_query($strSQL2);
$a=1;
?>
|
|
ตัวบ่งชี้ |
รายละเอียด |
จำนวน |
|
while($objResult2 = mysql_fetch_array($objQuery2))
{
?>
|
|
$cou=$objResult2["cou"]; $sumcou=$sumcou+$cou;
if($cou == "0")
{echo "$cou";}
else
{echo "$cou";}
?>
|
$id_indicator=$objResult2["id_indicator"];
echo"";?>
|
$a++;} ?>
รวม |
|
|
|
|
|
include('foot.php'); ?> |
|