[Resolved] How to handle prices

[sgtpepper]

Hello,

I am wondering how I can handle prices. I have a DB with a price field. I have the field set as 'double'.

When I display the field.
<? echo $row['price']; ?>

It displays the number but...how can I get it to add , to the price?

For example instead of

100000

100,000

I am not sure if the issue is with my DB or how I code php.

Thanks

[Pig]

money_format()

[sgtpepper]

Thanks...can you be a little more specific? Where does this get placed?

[lanjoky]

http://us4.php.net/manual/en/function.money-format.php see this page it will give u the info u need to use it

GL

[laserlight]

It should be the number_format() function.

Also, I would advise storing money as integers (e.g. number of cents) as the double type may have rounding errors common in floating point operations.