Additing Total

[zzz]

I run a loop to display information for certain account and each line has some numeric value. I need to add a total sum of all values in a table at the bottom. How do I do that?

[jpmoriarty]

well it will depend on what your loop is:

$total=0;
for($i=1;$i<10;$i++)
{
  $total += $i;
}
echo $total;

will give you $total = 1+2+3+4+...+8+9 = 45

[zzz]

This is great!

Here's how i pull the data from my db:

while ($myrow = mysql_fetch_row($result)) {

printf("<tr><td>%s</td><td>%s</td><td align=center>$%s</td><td><b>$%s</td></tr>\n",
$myrow[1], $myrow[2], $myrow[3], $myrow[4]);

[/COLOR]

Question: How do Specify to add only the last, i.e. $myrow[4] values?

[jpmoriarty]

$total=0;
while ($myrow = mysql_fetch_row($result))
{ 
printf("<tr><td>%s</td><td>%s</td><td align=center>$%s</td><td><b>$%s</td></tr>\n", 
$myrow[1], $myrow[2], $myrow[3], $myrow[4]);
$total += $myrow[4];
}
echo $total;

[zzz]

Thanks for putting my thoughts in order. Works great!