Re: [PHP] math calculations query

"Maxim Maletsky" <[EMAIL PROTECTED]> wrote: > SELECT > SUM(quantity)*SUM(total) As mySUM > FROM > table > WHERE Technically, this is correct based on what the original poster (below) stated he wanted, but that's not really what he wanted since there's no real world reason to calculate what he sta

RE: [PHP] math calculations query

PROTECTED]] Sent: Friday, April 27, 2001 4:31 AM To: [EMAIL PROTECTED] Subject: [PHP] math calculations query 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

RE: [PHP] math calculations query

EMAIL PROTECTED] Subject: Re: [PHP] math calculations query 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 to

Re: [PHP] math calculations query

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

Re: [PHP] math calculations query

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 tot

[PHP] math calculations query

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. Any