[ تمت الإجابة ]مشكلة في عرض مجموع العمود

<?php require_once('../Connections/config.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}

$colname_rs_projname = "-1";
if (isset($_GET['Proj_Name'])) {
$colname_rs_projname = $_GET['Proj_Name'];
}
mysql_select_db($database_config, $config);
$query_rs_projname = sprintf("SELECT * FROM projects WHERE Proj_Name = %s", GetSQLValueString($colname_rs_projname, "text"));
$rs_projname = mysql_query($query_rs_projname, $config) or die(mysql_error());
$row_rs_projname = mysql_fetch_assoc($rs_projname);
$totalRows_rs_projname = mysql_num_rows($rs_projname);

$colname_rs_masrof = "-1";
if (isset($_GET['Proj_Name'])) {
$colname_rs_masrof = $_GET['Proj_Name'];
}
mysql_select_db($database_config, $config);
$query_rs_masrof = sprintf("SELECT * FROM proj_masrofat WHERE Proj_Name = %s", GetSQLValueString($colname_rs_masrof, "text"));
$rs_masrof = mysql_query($query_rs_masrof, $config) or die(mysql_error());
$row_rs_masrof = mysql_fetch_assoc($rs_masrof);
$totalRows_rs_masrof = mysql_num_rows($rs_masrof);

mysql_select_db($database_config, $config);
$query_rs_lastn = "SELECT * FROM last_news";
$rs_lastn = mysql_query($query_rs_lastn, $config) or die(mysql_error());
$row_rs_lastn = mysql_fetch_assoc($rs_lastn);
$totalRows_rs_lastn = mysql_num_rows($rs_lastn);
?>

<table width="1024" border="0" align="center">
<tr>
<td align="center" valign="middle"><table width="1000" border="1" align="center">
<tr>
<td colspan="4" align="center" bgcolor="#CCCCCC"><strong>تقرير مصروفات مشروع والمتبقي له</strong></td>
</tr>
<tr>
<th width="301" align="center" valign="middle" bgcolor="#FDF9F7">اسم المشروع</th>
<th width="233" align="center" valign="middle" bgcolor="#FDF9F7">الميزانية</th>
<th width="233" align="center" valign="middle" bgcolor="#FDF9F7">المصروف</th>
<th width="233" align="center" valign="middle" bgcolor="#FDF9F7">المتبقي</th>
</tr>
<tr>
<td align="center" valign="middle" bgcolor="#FDF9F7"><strong><?php echo $row_rs_projname['Proj_Name']; ?></strong></td>
<td align="center" valign="middle" bgcolor="#FDF9F7"><strong><?php echo $row_rs_projname['Proj_Mezaniah']; ?></strong></td>
<td align="center" valign="middle" bgcolor="#FDF9F7"><strong><?php

mysql_select_db($database_config, $config);
$query_rs_masrof = "SELECT SUM(Sarf_Amount) FROM proj_masrofat";
$rs_masrof = mysql_query($query_rs_masrof, $config) or die(mysql_error());
while($row_rs_masrof = mysql_fetch_assoc($rs_masrof)){
echo $row_rs_masrof;}
?></strong></td>
<td align="center" valign="middle" bgcolor="#FDF9F7"><strong><?php echo $row_rs_projname['Proj_Mezaniah'] - $row_rs_masrof; ?></strong></td>
</tr>
</table></td>
</tr>
</table>
<p><br />
</p>

<?php
mysql_free_result($rs_projname);

mysql_free_result($rs_masrof);

mysql_free_result($rs_lastn);
?>