Counting SUM off some rowes

[kumschick]

Hi,

I would like to count the SUM of this output:

SELECT * FROM $shop WHERE client='$REMOTE_ADDR'
while($row=...)
  {
    $total=number_format($row[quantity]*$row[price], 2, '.', '\'');
    echo"$total"; // SUM OF THIS
  }

If there are many rows, and I would like to know the end price off all articels, how do i do this? in the DB i only have the [price/unit] and nothing else, not the subtotal.

The subtotal is calculated with: $total=number_format($row[quantity]*$row[price], 2, '.', '\'');

[LordShryku]

$ttl = 0;
while($row=...) {
   $total = number_format($row['quantity']*$row['price'], 2, '.', ',');
   echo $total;
   $ttl += $total;
}
echo $ttl;

[mrhappiness]

will

SELECT 
  *,
  quantity * price subtotal
FROM 
  $shop 
WHERE 
  client='$REMOTE_ADDR' 

work?
it should give you one more column called subtotal

[kumschick]

Yes, but I do not want to count the subtotal, but the total.

total = subtotal + subtotal + subtotal + ...
echo total

but i don't know how...!

[mrhappiness]

SELECT
SUM(quantity * price) subtotal
FROM
$shop
WHERE
client='$REMOTE_ADDR'