"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
SELECT
SUM(quantity)*SUM(total) As mySUM
FROM
table
WHERE
...
Sincerely,
Maxim Maletsky
Founder, Chief Developer
PHPBeginner.com (Where PHP Begins)
[EMAIL PROTECTED]
www.phpbeginner.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECT
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
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
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
5 matches
Mail list logo
