Adding up query results
| From: | Nathan Mealey | Date: | Sun, 16 Jan 2005 04:17:02 +0000 |
| Subject: | Adding up query results | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-206460@lists.php.net to get a copy of this message | ||
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