>I'd like to add all values for $purchase_price that are returned, how do I
>do this?
>Here's what i have now.
><?php
>$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)) {
echo "$purchase_price<BR>\n";
$total += $purchase_price; # Short-hand for $total = $total +
$purchase_price;
}
>?>
Actually, it might be better to just change your SQL to:
select SUM(purchase_price) from assets where order_number = '$order_number'
The SQL SUM() will be *MUCH* faster than your while () loop.
--
Like Music? http://l-i-e.com/artists.htm
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
