Dear Mr News:
On Fri, Jun 28, 2002 at 12:41:56PM -0700, news.php.net wrote:
> I'd like to add all values for $purchase_price that are returned,
> how do I do this?
>
> $result = mysql_query("SELECT purchase_price FROM assets where
> order_number='$order_number' ORDER BY $desc");
$total = 0;
> while(list($purchase_price) = mysql_fetch_row($result)) {
$total = $total + $purchase_price;
}
That works if you want to process each row as you go along AND get a
total. You could also go straight for the total in the query if you
don't need line by line processing:
SELECT sum(purchase_price) as totl FROM assets GROUP BY order_number
where order_number='$order_number';
--Dan
--
PHP classes that make web design easier
SQL Solution | Layout Solution | Form Solution
sqlsolution.info | layoutsolution.info | formsolution.info
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
