[RESOLVED] Sum of values in an array/While loop

[TheStalker]

Hi,

I need some help on how to add all the values i have in my table from my database.

Fisrt here is the code for my table:

while($row = mysql_fetch_array($results)) 
	{	
		echo "<tr>";
			echo "<td> ".$row['Date'] . "</td>";
			echo "<td>".$row['Type'] . "</td>";
			echo "<td>£".$row['amount'] . "</td>";
		echo "</tr>";

Now i want to add the values in the $row['amount'] to get a total. Is there any easy way to do this so i can echo the total?

Any help or advice would be great. Thanks 🙂

[laserlight]

Yes. Set a counter, say $total = 0; before the loop, then in the loop just do $total += $row['amount'];

You could also use the SQL statement to do this directly.

[TheStalker]

laserlight;10895996 wrote:

Yes. Set a counter, say $total = 0; before the loop, then in the loop just do $total += $row['amount'];

That worked really well thanks ! Could i ask you just to explain how it works ?

[laserlight]

The idea is simply to add each amount to the total.

[TheStalker]

sorry i was being a bit slow, thanks for the help 🙂