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.


-Micah

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.

http://php.net/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

http://www.thelonecoder.com
continuing the struggle against bad code

http://www.thumbnailresume.com
--




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]>
Cc: <php-db@lists.php.net>
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);

$ 28.8

I would like the result to be $28.80

Thanks for your help Micah.

Ron

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` )
VALUES (
'8.00'
)

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
problem?

-Micah


On 12/15/2007 07:13 PM, Ron Piggott wrote:
INSERT INTO rate_plans VALUES ( '12', 'One Week', '1', '2', '2',
'8.00' )

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?

Ron

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:

rate decimal(4,2)

Example: Right now it is giving me 800 instead of 8.00

Ron

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Reply via email to