[RESOLVED] Currency question

[Double_M]

Hey all,

Might be mainly a bit of an sql question but here it is anyway.
i want to store currency data into an sql database like $233.56 but if theres just $233.00 it only stores $233. Is there a way i can make it store the .00 aswell?

Ive tried the function 'round(blabla, 2);' but if there isnt any .00 pulled from the db it just puts $233.

Thanks for any help.

[Double_M]

Well i got a way round it. Im sure you know:

number_format($blabla, 2);

😉

[Installer]

Or you can use the FORMAT() function in your SELECT queries.

[MarkR]

What type are you using in the database? I recommend using something like DECIMAL(8,2)

Or if your db supports it, MONEY (Which will be similar)

Mark