database question

I wonder how to make the price-database-table, when I have prices like 100.000,
200.000
but also 2.200.200 (2 million)?>
This it what I use, but I cannot write 2.200.200 with this, only 2000.000 not
even 2 000.000:
`price` float(10,3) NOT NULL default '0.000',
Thanks for helping me.

You need to store the values in the database without any formatting and then
apply the formating to the number when it is brought to the page.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
www.valleybiz.net

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
www.macromedia.com/support/forums/team_macromedia

"Ulitasch" <webforumsuser (AT) macromedia (DOT) com> wrote

I wonder how to make the price-database-table, when I have prices like
100.000,
200.000
but also 2.200.200 (2 million)?
This it what I use, but I cannot write 2.200.200 with this, only 2000.000
not
even 2 000.000:
`price` float(10,3) NOT NULL default '0.000',
Thanks for helping me.