Format number question

[182x]

Hey guys,

In my datbase I have a field called amount which is a float so if I enter 12.24 thats fine but if I add .06 ot that it will be entered in the database and displayed as 12.3 rather than 12.30 is there a way to change this?

Thanks for any help.

[Psycho]

In the database? I don't think so. What does it matter how it is stored in the database. Just use number_format() to format the number appropriately when echoing it to the page.

http://us3.php.net/manual/en/function.number-format.php

[esukf]

If you're using mysql, you can change the data type of the column in the database to decimal(M,D) where M is the total number of digits and D the number of digits after the decimal point.

As mjdamato said you can just format the number after it's been pulled from the database using number_format()

[182x]

Nice one thanks guys for the syntax of number_format() when dealing with session variables I have to leave off the quotes is the following correct:

[code]
echo number_format($HTTP_SESSION_VARS['curr'],2)
[/code]

or should it be:

[code]
echo number_format("$HTTP_SESSION_VARS['curr']",2)
[/code]

[Orio]

[code]echo number_format($HTTP_SESSION_VARS['curr'],2);[/code]
is the right version.

Orio.