oh, I am such a bone head.. but the actual question was how to calculate the
totals.
i have a column on my form that says $qry["price"]*$qry["quantity"] which
gives me a column of totals but my question is how to total that up???
any ideas?
"David VanHorn" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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]
>
--
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]
