Hi,

I have a form that basically retrieves data from a MySQL database. One of the fields within the database has a dollar amount. I have used the following code to retrieve the data but like a running total of the amount of records I would like a running total of the field "Arrears Paid" for the records selected. Can anyone point me in the right direction on how to code this? The only thing I could find on the subject doesn't use a database to get its numbers from.

Thanks -

PHP Code:

while ($query_res = mysql_fetch_array($query_run)) {
        print "<b>Date Entered: " . $query_res['Entered_Month'] . " " . $query_res['Entered_Day'] . ", " . $query_res['Entered_Year'] . "</b><br>";
        print "Agent: " . $query_res['Agent'] . "<br>";
        print "Customer: " . $query_res['Customer_Name'] . "<br>";
        print "Account: " . $query_res['Account_Number'] . "<br>";
        print "Product: " . $query_res['Product_Type'] . "<br>";
        print "Balance: " . $query_res['Balance_Owing'] . "<br>";
        print "Arrears Paid: " . $query_res['Arrears_Paid'] . "<br>";
        print "Settled: " . $query_res['Amount_Settled'] . "<br>";
        print "Settled On: " . $query_res['Date_Settled'] . "<br>";
        print "<hr>";
        } 


PHP Code:

<?php

$totalArrears = 0.00;

while ($query_res = mysql_fetch_array($query_run)) 
{ 
        print "<b>Date Entered: " . $query_res['Entered_Month'] . " " . $query_res['Entered_Day'] . ", " . $query_res['Entered_Year'] . "</b><br>"; 
        print "Agent: " . $query_res['Agent'] . "<br>"; 
        print "Customer: " . $query_res['Customer_Name'] . "<br>"; 
        print "Account: " . $query_res['Account_Number'] . "<br>"; 
        print "Product: " . $query_res['Product_Type'] . "<br>"; 
        print "Balance: " . $query_res['Balance_Owing'] . "<br>"; 
        print "Arrears Paid: " . $query_res['Arrears_Paid'] . "<br>"; 
        print "Settled: " . $query_res['Amount_Settled'] . "<br>"; 
        print "Settled On: " . $query_res['Date_Settled'] . "<br>"; 
        print "<hr>"; 

        $totalArrears += (double) $query_res['Arrears_Paid']

        }

// now $totalArrears will contain the grand total of all arrears.

?>

Hi Kyrnt,

Thanks so much for your reply. I have been killing myself on what I'm sure is a very easy problem. I added your code but I'm getting a Parse Error on the last line. I have tried it with and without the ";". Could you possibly see another alternative?

The line I'm getting the parse error on is: $totalArrears += (long) $query_res['Arrears_Paid'];

Thanks Again

merlin, try it by casting to (double) instead of (long). I did accidentally leave off the semicolon -- it is required -- thanks for catching that mistake.

And just to be safe, let's add some additional parentheses:

PHP Code:

$totalArrears += ((double) $query_res['Arrears_Paid'] );