tyler Posted October 7, 2003 Share Posted October 7, 2003 So, for some reason when someone puts in .2 for 2 cents, it thinks its 20 cents. mysql> select FORMAT(.4,2) from types where username=\'12345\'; +--------------+ | FORMAT(.4,2) | +--------------+ | 0.40 | The field is set for decimal. I\'m out of ideas. This doesn\'t help me when it comes to money. Tyler Quote Link to comment Share on other sites More sharing options...
shivabharat Posted October 8, 2003 Share Posted October 8, 2003 I am not quiet clear with what you want say if the user enter .2 instead of 20 you can write a script which will identify them and once done .2 * 10 = 20 ?? I think I am making a wild guess. If you can be bit clear we can help you out. :roll: Quote Link to comment Share on other sites More sharing options...
tyler Posted October 8, 2003 Author Share Posted October 8, 2003 Sorry, let me explain ;-) It\'s a investment company. Therefore, someone says they deposit .2 (2 cents) the system thinks its 20 cents. The only way they would be able to put in 2 cents is if they put in .02 Tyler Quote Link to comment Share on other sites More sharing options...
DylanBlitz Posted October 8, 2003 Share Posted October 8, 2003 umm, .2 of a dollar is not 2 cents it\'s 20 cents. 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.