Adding totals from row results

[micmac]

Hi all,
If i have the following:

$sql2 = "SELECT * FROM orders WHERE ordNumber='" . $_GET["ordNumber"] . "'";
$result2 = mysql_query($sql2);
while($alldata = mysql_fetch_array($result2)){
$ordTotal = $alldata["ordTotal"];
$ordQty = $alldata["ordQty"];
$order_total = number_format($ordTotal*$ordQty, 2, ".", ",");

how can i add up all the rows? At the moment, if i echo the above i get two seperate values ie. one for each row.

Cheers,
micmac

[tserbis]

$ordTotal = 0.0;
while ( ... ) {
...
$ordTotal += $alldata["ordTotal"];
...
}

OR

use select sum(...) from ... where ...