show the exact and complete code that you have now.
Code: Select all
$colname_rsProperty = "-1";
if (isset($_GET['recordID'])) {
$colname_rsProperty = $_GET['recordID'];
}
mysql_select_db($database_hostprop, $hostprop);
$query_rsSum = sprintf("SELECT host_editpropUtil.utilityAmount, host_editprop.prop_id, host_editpropUtil.prop_id FROM host_editpropUtil, host_editprop WHERE host_editpropUtil.prop_id = host_editprop.prop_id AND host_editprop.prop_id = %s", GetSQLValueString($colname_rsProperty, "text"));
$rsSum = mysql_query($query_rsSum, $hostprop) or die(mysql_error());
$totalRows_rsSum = mysql_num_rows($rsSum);
$grandTotal = 0;
// use a loop here {
$row_rsSum = mysql_fetch_assoc($rsSum);
$grandTotal += $row_rsSum['utilityAmount'];
// and display the contents of the row
//}
function DoFormatCurrency($theObject,$NumDigitsAfterDecimal,$DecimalSeparator,$GroupDigits,$CurrencySymbol) {
$currencyFormat=$CurrencySymbol.number_format($theObject,$NumDigitsAfterDecimal,$DecimalSeparator,$GroupDigits);
return ($currencyFormat);
}
<?
session_start();
if(!$_SESSION['loggedIn']) // If the user IS NOT logged in, forward them back to the login page
{
header("location:Login.html");
}
?>Code: Select all
<table width="940" border="1" align="left" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#B5EC2B" class="table-text">Utility</td>
<td bgcolor="#B5EC2B" class="table-text">Date Paid</td>
<td bgcolor="#B5EC2B" class="table-text">Start Date</td>
<td bgcolor="#B5EC2B" class="table-text">End Date</td>
<td bgcolor="#B5EC2B" class="table-text">Amount</td>
<td bgcolor="#B5EC2B" class="table-text">Tenants</td>
<td bgcolor="#B5EC2B"><span class="table-text">Delete Utility</span></td>
</tr>
<?php do { ?>
<tr>
<td class="table-text"><a href="utility-breakdown.php?recordID=<?php echo $row_rsProperty['utilityID']; ?>"><?php echo $row_rsProperty['utilName']; ?></a></td>
<td class="table-text"><?php echo date('D, d/m/Y',strtotime($row_rsProperty['utilityDatePaid'])); ?></td>
<td class="table-text"><?php echo date('D, d/m/Y',strtotime($row_rsProperty['utilitySD'])); ?></td>
<td class="table-text"><?php echo date('D, d/m/Y',strtotime($row_rsProperty['utilityED'])); ?></td>
<td class="table-text"><?php echo DoFormatCurrency($row_rsProperty['utilityAmount'], 2, ',', '.', '£ '); ?></td>
<td class="table-text"><?php echo $row_rsProperty['utilityStudAmount']; ?></td>
<td class="table-text"><a href="delete-utility.php?utilityID=<?php echo $row_rsProperty['utilityID']; ?>">Delete </a></td>
</tr><?php } while ($row_rsProperty = mysql_fetch_assoc($rsProperty)); ?>
<tr>
<td class="table-text"> </td>
<td class="table-text"> </td>
<td class="table-text"> </td>
<td class="table-text"> </td>
<td class="table-text"><?php
/* $query = "SELECT host_editpropUtil.SUM(utilityAmount), host_editprop.prop_id WHERE host_editprop.prop_id = $recordID";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result))
{
echo $row['SUM(utilityAmount)'];
}*/
//echo $row_rsSum['SUM(host_editpropUtil.utilityAmount)'];
//echo $row_rsSum['utilityTotal'].'<br />';
//echo $total
echo $grandTotal;
?></td>
<td class="table-text"> </td>
<td class="table-text"> </td>
</tr>
</table>