|
Posted by mantrid on 10/07/06 18:36
I am trying to take an integer and divide it by 100 to give a decimal to
store in my database. The field in my mysql database is set to decimal(4,2)
My php is
$price=number_format($price/100,2);
Ive also tried
$price=number_format($price,2)/100;
but neither work it keeps rounding any value less than 100 to 1 whereas I
want it to store the value to two DP
eg
80 becomese 1 instead of 0.8
180 becomes 2 instead of 1.8
does anyone know how to do this?
Ian
Navigation:
[Reply to this message]
|