what data type would money be when setting data type for field?

[spewn]

i'm trying to store prices in mysql...i'm editing the field name and it asks for data type...i've tried decimal, float, double, integer. nothing keeps the X.XX format.

any ideas?

- g

 

[sleipnir214]

I recommend you use decimal.

Integer stores, well, integers. Float and double are imprecise.

What does "nothing keeps the X.XX format" mean?



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[spewn]

i got it...i used decimal and changed the values in the maxlength,decimal places.

thanks for your help! - g