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 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 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 Link to comment https://forums.phpfreaks.com/topic/211641-what-type/#findComment-1103323 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.