=$no;?> |
fetchArray($result6);
echo $rs6['prefix'];
?>
echo $rs4['lname'];?>
|
execQuery($query6);
$rs6 = $dbObj->fetchArray($result6);
$dbObj->freeresult($rs6);
echo number_format($rs6['Sum']) ;
?> |
$day = $rs6['Sum']/6 ;
echo number_format($day) ;
?> |
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";
}
?> |
$sql = " SELECT SUM(moneybudget1) AS moneybudget1 FROM dev_his dh Where dh.Year_std='$Year_std' and dh.perid ='$rs[perid]' ";
$result4 = mysql_query($sql);
$rs4 = mysql_fetch_array($result4) ;
$sql = " SELECT SUM(moneybudget2) AS moneybudget2 FROM dev_his dh Where dh.Year_std='$Year_std' and dh.perid ='$rs[perid]' ";
$result6 = mysql_query($sql);
$rs6 = mysql_fetch_array($result6) ;
$sql = " SELECT SUM(moneybudget3) AS moneybudget3 FROM dev_his dh Where dh.Year_std='$Year_std' and dh.perid ='$rs[perid]' ";
$result7= mysql_query($sql);
$rs7 = mysql_fetch_array($result7) ;
$sql = " SELECT SUM(moneybudget4) AS moneybudget4 FROM dev_his dh Where dh.Year_std='$Year_std' and dh.perid ='$rs[perid]' ";
$result8 = mysql_query($sql);
$rs8 = mysql_fetch_array($result8) ;
?>
$query = " SELECT * FROM dev_his WHERE Year_std='$Year_std' and perid = '".$rs['perid']."' Order By HisId ";
$result2 = mysql_query($query);
while($rss = mysql_fetch_array($result2)){ ;
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
|
=$rss['cname'];?> |
execQuery($query6);
$rs6 = $dbObj->fetchArray($result6);
$dbObj->freeresult($rs6);
echo number_format($rs6['Sum']) ;
?> |
$day = $rs6['Sum']/6 ;
echo number_format($day) ;
?> |
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";
}
?> |
$sql = " SELECT SUM(moneybudget1) AS moneybudget1 FROM dev_his dh Where dh.Year_std='$Year_std' and dh.cname ='$rss[cname]' ";
$result4 = mysql_query($sql);
$rss4 = mysql_fetch_array($result4) ;
$sql = " SELECT SUM(moneybudget2) AS moneybudget2 FROM dev_his dh Where dh.Year_std='$Year_std' and dh.cname='$rss[cname]' ";
$result6 = mysql_query($sql);
$rss6 = mysql_fetch_array($result6) ;
$sql = " SELECT SUM(moneybudget3) AS moneybudget3 FROM dev_his dh Where dh.Year_std='$Year_std' and dh.cname='$rss[cname]' ";
$result7= mysql_query($sql);
$rss7 = mysql_fetch_array($result7) ;
$sql = " SELECT SUM(moneybudget4) AS moneybudget4 FROM dev_his dh Where dh.Year_std='$Year_std' and dh.cname ='$rss[cname]' ";
$result8 = mysql_query($sql);
$rss8 = mysql_fetch_array($result8) ;
?>
freeresult($result);
?>