John, Try using the number_format function.
Bev -----Original Message----- From: John Wulff [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 29, 2002 3:10 PM To: [EMAIL PROTECTED] Subject: [PHP] Limiting number of decimal places reported How do I limit the number of decimal places returned in this query? <?php $result2 = mysql_query("SELECT sum(purchase_price) as total FROM assets where order_number='$order_number'"); while(list($order_total) = mysql_fetch_row($result2)) { print ("$order_total"); } ?> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php