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