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
> How do I limit the number of decimal places returned in this query?
>
>
> $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");
If you were
round($order_total), floor("), ceil(") are some options.
> How do I limit the number of decimal places returned in this query?
>
>
> $result2 = mysql_query("SELECT sum(purchase_price) as total FROM assets
> where order_number='$order_number'");
>
> while(list($order_total) = mysql_fetch_row($resu
3 matches
Mail list logo
