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 <ron.php@xxxxxxxxxxxxxxxxxx> > Organization: Acts Ministries Christian Evangelism > Reply-To: <ron.php@xxxxxxxxxxxxxxxxxx> > Date: Sun, 16 Dec 2007 12:55:01 -0500 > To: Micah Stevens <micah@xxxxxxxxxxxxxxxxxx> > Cc: <php-db@xxxxxxxxxxxxx> > Subject: Re: 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 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
