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 Mealey
Website Manager & Administrative Director
Cycle-Smart, Inc.
P.O. Box 1482
Northampton, MA
(413) 210-7984
(512) 681-7043 Fax

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

Reply via email to