Using commas in MySQL Decimal fields
Posted on 2007-03-19
I am having problems with entering a price into a MySQL decimal (10,2) field. If a person enters 2118.56 in the HTML form, the record enters OK. However, if they enter 2,118.56, the price field in the record is 2.00.
I am using PHP to insert the record.
Should I be using addslashes, or something else?