"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 stated he wanted. He must really want the
total monetary value of the items returned by the query. That's calculated
by multiplying the quantity of each record by the price of each item and
summing that for each record. So the correct SQL statement is:
SELECT SUM(price*quantity)
FROM table_name
WHERE ...
If he doesn't want to run the query above in addition to his existing query
to return individual records, he can calculate this total programatically.
Sean, in this case, as you're looping through the records do:
$amount_record = $price * $quantity;
$amount_total += $amount_record;
After the loop is complete, $amount_total will contain the value you want.
Alternately, the first line can be eliminated by calculating the amount for
each record within the query.
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] wrote:
> 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.
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/
--
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]
