Running Balance using an array MySql

[richiejones24]

I am having some trouble with the code below i have a table that contains financial  transactions, and i am trying to display a running balance, but its not working its just displaying the original transaction amount, i need the code to get the balance from the previous loop and add the transaction amount in the current loop.

 

<?

$i = 0;
$result = mysql_query("SELECT * FROM transactions WHERE UIN ='$uincookie' $limit ");
while($row = mysql_fetch_array($result)) {


if ($i == 0) { $bal[] = $row[6] + 0.00; } else { $bal[] = $row[6] + $bal[$i]; }



print "<tr class=\"\"><td style=\"vertical-align: middle; text-align: center;\">$row[2]</td><td style=\"vertical-align: middle; text-align: center;\" class=\"read\"><span class=\"read\" style=\"vertical-align: middle; text-align: center;\">$row[3]</span></td><td>$row[4]</td><td>$row[5]</td><td>£$row[6]</td><td>£" . $bal[$i] . "</td></tr>\n";

$i++;
$p++;                                    //The balances starts at 2 so need to add rows per page to 2!
}


?>

[Drummin]

if ($i == 0) { $bal = $row[6] + 0.00; } else { $bal = $row[6] + $bal;}