Adding up query results

[Nathan Mealey <nathan@xxxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxxx
(413) 210-7984
(512) 681-7043 Fax

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php