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