[PHP-DB] Re: Adding Up MySQL Results

I guess this is what you mean: sum(quantity)*priceprice 450.00 15.00 479.99 29.99 ... ... is that right? JeRRy wrote: I run this mysql query: "select sum(quantity)*price,price from sale where dvd_id=1 group by price"; I get this result:

[PHP-DB] Re: Adding Up MySQL Results

I run this mysql query: "select sum(quantity)*price,price from sale where dvd_id=1 group by price"; I get this result: sum(quantity)*price price 450.00 15.00 29.99 29.99 I want to display the sum of the values in the first column (450.00+29.99), but I can