At 08:31 PM 4/26/01 +0100, [EMAIL PROTECTED] 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
