MYSQL HELP .. PLEASE ANYONE HELP ME WITH THIS

[Luther_Caloring]

[Psycho]

You would best be done in the processing code after you run the query.

 

 

$query = "SELECT * FROM tbl_payment ORDER BY `Payment No.`";
$result = mysql_query($query) or die (mysql_error());
 
$total = 0;
while($row = mysql_fetch_assoc($result))
{
    $total += $row['Amount'];
}

[vinny42]

It's called a "rolling total" or "cumulative sum, and MySQL can do that for you. Google for instructions like: http://develop-for-fun.blogspot.nl/2012/06/mysql-select-query-make-cumulative-sum.html