=$no;?> |
|
execQuery($query);
$rs1 = $dbObj->fetchArray($result1);
$num1 = $dbObj->_numrows;
if( $num1 > 0 ) {
echo $num1;
} else {
echo "ยังไม่มีข้อมูล";
}
?> |
execQuery($query);
$rs1 = $dbObj->fetchArray($result1);
$num1 = $dbObj->_numrows;
if( $num1 > 0 ) {
echo $num1;
} else {
echo "0";
}
?> |
execQuery($query);
$rs1 = $dbObj->fetchArray($result1);
$num1 = $dbObj->_numrows;
if( $num1 > 0 ) {
echo $num1;
} else {
echo "0";
}
?> |
execQuery($query);
$rs1 = $dbObj->fetchArray($result1);
$num1 = $dbObj->_numrows;
if( $num1 > 0 ) {
echo $num1;
} else {
echo "0";
}
?>
|
execQuery($query);
$rs1 = $dbObj->fetchArray($result1);
$num1 = $dbObj->_numrows;
if( $num1 > 0 ) {
echo $num1;
} else {
echo "0";
}
?> |
execQuery($query6);
$rs6 = $dbObj->fetchArray($result6);
$dbObj->freeresult($rs6);
echo number_format($rs6['Sum']) ;
?> |
$day = $rs6['Sum']/6 ;
echo number_format($day) ;
?> |
$sql = " SELECT SUM(moneybudget1) AS moneybudget1 FROM dev_his dh ,dev_hrperson dp Where dh.Year_std='$Year_std' and dp.perid = dh.perid and dp.poscode ='$rs[poscode]' ";
$result4 = mysql_query($sql);
$rs4 = mysql_fetch_array($result4) ;
$sql = " SELECT SUM(moneybudget2) AS moneybudget2 FROM dev_his dh ,dev_hrperson dp Where dh.Year_std='$Year_std' and dp.perid = dh.perid and dp.poscode ='$rs[poscode]' ";
$result5 = mysql_query($sql);
$rs5 = mysql_fetch_array($result5) ;
$sql = " SELECT SUM(moneybudget3) AS moneybudget3 FROM dev_his dh ,dev_hrperson dp Where dh.Year_std='$Year_std' and dp.perid = dh.perid and dp.poscode ='$rs[poscode]' ";
$result7= mysql_query($sql);
$rs7 = mysql_fetch_array($result7) ;
$sql = " SELECT SUM(moneybudget4) AS moneybudget4 FROM dev_his dh ,dev_hrperson dp Where dh.Year_std='$Year_std' and dp.perid = dh.perid and dp.poscode ='$rs[poscode]' ";
$result8 = mysql_query($sql);
$rs8 = mysql_fetch_array($result8) ;
?>
|
|
|
|
freeresult($result);
?>