Re: math calculations query
| From: | David VanHorn | Date: | Thu, 26 Apr 2001 19:20:18 +0000 |
| Subject: | Re: math calculations query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-50486@lists.php.net to get a copy of this message | ||
At 08:31 PM 4/26/01 +0100, sean@networkdata.co.uk wrote:
hi all, i have a script which selects description, price and quantity from a mysql table. i have displayed the results on a page in the form of description, price, quantity but I was wondering how best to go about calculating a total total, ie. sum of quantitys multiplied by sum of prices.Generally, that's not how you do that. You'd calculate "extended" prices based on quantity of item and price, then add all extended prices. 1 Thingy $5 Ext= $5 2 SuperThingy $3 Ext=$6 Total is $11 As opposed to 3 * $8 by the method you described. -- Dave's Engineering Page: http://www.dvanhorn.org Where's dave? http://www.findu.com/cgi-bin/find.cgi?kc6ete-9