php - mysql keeps removing the zero's at start and/or end -
I have a simple form where the user enters a number (the price of the product) Ends with (1.50). But MESQL retains the vacuum at 1.5 to 1.5 instead of 1.5.
I use the field type double in the table and the php code is a simple form with 1 text box that gives the number to DB.
DCOders should post comments as comments. If you need a DCIML to represent the price, you'll be back zero.
And you should always format the output.
Comments
Post a Comment