ADDITNG TOTAL ...

[Anon]

I need help with this. I was able to retreive data from a db but I'd like to add total at the bootm of the printed table. Any suggestions based on this this code:

while ($myrow = mysql_fetch_row($result)) {
if ($myrow[7] != 3){
printf("<tr><td>%s</td><td>$%s<td</tr>\n",
$myrow[0], $myrow[7]);
}
}

TIA

[rrijnders]

<font color=blue>
$total = 0;
while ($myrow = mysql_fetch_row($result)) {
&nbsp;if ($myrow[7] != 3){
&nbsp;&nbsp;printf("<tr><td>%s</td><td>$%s<td</tr>\n",$myrow[0], $myrow[7]);
&nbsp;&nbsp;$total = $total + $myrow[7];
&nbsp;}
}
printf("<tr><td>&amp;nbsp;</td><td>$%s<td</tr>\n",$total);
</font>

...or something to that affect.

-- Rich

[Anon]

Rich,

Thanks a lot, this is exactly what I needed! Simple and light code that works!