Re: Adding up query results

From: Date: Sun, 16 Jan 2005 07:26:58 +0000
Subject: Re: Adding up query results
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-206466@lists.php.net to get a copy of this message
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


« previous php.general (#206466) next »