xtiancjs Posted April 2, 2006 Share Posted April 2, 2006 Hi all, I have a field in my table that requires a default value of 2.5, The field is a basic int field, in phpmy admin when I put the default value at 2.5, upon save it automatically rounds down to a 2, can anybody help me with this. I'm sure I am missing something obviousxtian Quote Link to comment Share on other sites More sharing options...
toplay Posted April 2, 2006 Share Posted April 2, 2006 An integer type holds whole numbers (i.e. 1, 15, 30, 100, etc.). You have to change the type to hold a floating point number (float/decimal). See:[a href=\"http://dev.mysql.com/doc/refman/4.1/en/numeric-type-overview.html\" target=\"_blank\"]http://dev.mysql.com/doc/refman/4.1/en/num...e-overview.html[/a] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.