computermax2328 Posted June 7, 2012 Share Posted June 7, 2012 Hello again, I want to store an average in MYSQL, for example .897. What data type should I use? I am currently using decimal(10,3), but the database is out putting numbers like 0.897. From my understanding the "m" in decimal(m,0) has to be greater than the "0." Any suggestions?? Quote Link to comment https://forums.phpfreaks.com/topic/263814-storing-an-average/ Share on other sites More sharing options...
litebearer Posted June 7, 2012 Share Posted June 7, 2012 the type you are using is fine. the real question is, how do you want the value displayed on the web page? Quote Link to comment https://forums.phpfreaks.com/topic/263814-storing-an-average/#findComment-1351909 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.