Posted by Chris on 01/16/05 09:26

You should be able to do this:

select sum(quantity*price) from sale where dvd_id=1

Chris


Nathan Mealey wrote:

> I hope someone can help with this frustratingly simple (I assume!)
> question I have.
>
> 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 cannot figure out how to do this! Can someone
> clue me in?
>
> Thanks a million,
> Nathan
> --
> Nathan Mealey
> Website Manager & Administrative Director
> Cycle-Smart, Inc.
> P.O. Box 1482
> Northampton, MA
> 01061-1482
> nathan@cycle-smart.com
> (413) 210-7984
> (512) 681-7043 Fax
>

• Prev in thread: Adding up query results
• Next in forum: which is best php editor?
• Prev in forum: PHP date returns wrong value ??
• Thread view: Adding up query results

[Reply to this message]