[RESOLVED] ending a loop and echoing the summary ???

[qrt123]

Hi there.

I have a query to a MySql database. Whin echoing the result I use:

echo ("<table>bla bla...");

while ($row = mysql_fetch_assoc($resultat))
  {
// Here goes the rows
echo ("<tr><td>bla bla...")

and at the end it closes like:

}
echo("</table>");

But, I would like to finish the table wit a summary of the data in the rows.
How do i end the loop after the last line, and print out a line at the very end, with the summary ?

Or, do I have to manually format that summaryline and put it outside the table with the data ?
I do have the code for the summary. This is merely at question of how to format it like the table with the rows.
U know what i mean ?

[Weedpacket]

}
echo "<tr><td>summary blah blah...";
echo "</table>";

For HTML bonus points, put the summary lines in a <tfoot> element.

[NogDog]

However, you may need to any calculations in the loop itself.

<table>
<?php
$sum = 0;
while(...) {
   echo "...";
   $sum .= $row['foobar'];
}
echo "<tr><td>Sum:</td><td>$sum</td></tr>\n";
?>
</table>

[qrt123]

Thx.
Now it works.