Without trying it, I would assume php (since it's typeless) would just
cast the string back into a number? I wouldn't do it for another reason-
possible loss of accuracy.
On 12/16/2007 10:08 AM, Stephen Johnson wrote:
You will lose your decimal places during normal calculations...
But you can display them back to the user using number_format.
Bear in mind that you should always pass the formatted number into a
different variable as you will NOT be able to perform any further
calculations on the formatted variable since it now considered a string.
Hope this helps
Stephen Johnson c | eh
The Lone Coder
continuing the struggle against bad code
From: Ron Piggott <[EMAIL PROTECTED]>
Organization: Acts Ministries Christian Evangelism
Reply-To: <[EMAIL PROTECTED]>
Date: Sun, 16 Dec 2007 12:55:01 -0500
To: Micah Stevens <[EMAIL PROTECTED]>
Subject: Re: [PHP-DB] decimal point
Ok. I have this resolved.
One more question about this --- is there any way I may keep the 2
decimal places when I use math to manipulate the variable ---
$rate_plan_rate = ($rate_plan_rate / 100) * (100 - $discount);
I would like the result to be $28.80
Thanks for your help Micah.
On Sat, 2007-12-15 at 19:58 -0800, Micah Stevens wrote:
If I make a test table with a field that is DECIMAL(4,2), I can:
INSERT INTO `testaa` ( `a` )
Then I can
SELECT * FROM `testaa`
I get '8.00' from the 'a' field.
It looks like you're using an abstraction library? Perhaps that's the
On 12/15/2007 07:13 PM, Ron Piggott wrote:
INSERT INTO rate_plans VALUES ( '12', 'One Week', '1', '2', '2',
When I use
$advertisement_rate = mysql_result($rate_plan_result,0,"rate");
$advertisement_rate has a value of 800 instead of 8.00 --- how can I get
my 2 decimal places back?
On Sat, 2007-12-15 at 18:18 -0800, Micah Stevens wrote:
What's your insert statement?
On 12/15/2007 05:11 PM, Ron Piggott wrote:
How do I get the decimal point back when I am retrieving from a column
that is set up as:
Example: Right now it is giving me 800 instead of 8.00
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php