Danny620 Posted August 24, 2010 Share Posted August 24, 2010 Hi what type is it in mysql db to store a decimal e.g 2.99 i try int but that just rounds it up to 3 Quote Link to comment https://forums.phpfreaks.com/topic/211641-what-type/ Share on other sites More sharing options...
kenrbnsn Posted August 24, 2010 Share Posted August 24, 2010 The int type is for storing integers not decimal numbers. There is a DECIMAL type & a FLOAT type. BTW, this question has nothing to do with PHP, so I'm moving it to the MySQL area.... Ken Quote Link to comment https://forums.phpfreaks.com/topic/211641-what-type/#findComment-1103286 Share on other sites More sharing options...
Danny620 Posted August 24, 2010 Author Share Posted August 24, 2010 Thanks Ken that fixed it float Quote Link to comment https://forums.phpfreaks.com/topic/211641-what-type/#findComment-1103323 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.