[RESOLVED] SUM up

[navster]

How can I SUM values from a MySQL database just using PHP?

Basically I have this

while ($row = mysql_fetch_assoc($hire)) {

$cart_qty = $row[qty];
$cart_cost = $row[cost];

$math = $cart_cost * $cart_qty;

}

So now I need to do a SUM on $math to get a total.. Any ideas?

[Sxooter]

why not do it in the query:

select sum(amount*qty) from db where cust_id=1234567

(edited to fix typoes. if (!had_coffee){ post = false; get_coffee()}

[navster]

Thanks Sxooter, you're a star 😃