Currency in MySQL

[Nixon]

Hi All,

What is the best option for storing currency values in MySQL. Is there a certain way to do it so that when 1.7 is entered it is automatically converted to 1.70 or 14.7 to 14.70?

Thanks. Jack.

[YappyDog]

You store it normally and then use something like printf() or sprintf() to format and display it the way you want.

http://us3.php.net/manual/en/function.printf.php

http://us3.php.net/manual/en/function.sprintf.php

[Nixon]

Thanks, that fixed it fine.

Regards. Jack