dynamic text field/mysql

[smitty1140]

I have a dynamic text field that gets a price entered into. When the form is submitted, the database (MYSQL) shows it as a rounded number.

For Example:

entered price is 5.95
in the mysql database the data says 5

[Nile]

PHP floor().

[blm126]

It sounds like your table schema is wrong. The column it is being stored in is probably defined as "price INT" as opposed to "price FLOAT(11)". Since integers can not contain decimal points, MySQL is truncating the information, and storing just the whole integer portion.