Jump to content


Photo

Money


  • Please log in to reply
3 replies to this topic

#1 tyler

tyler
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 07 October 2003 - 10:07 PM

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

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 08 October 2003 - 06:03 AM

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:
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks

#3 tyler

tyler
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 08 October 2003 - 01:14 PM

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

#4 DylanBlitz

DylanBlitz
  • Members
  • PipPipPip
  • Advanced Member
  • 99 posts
  • LocationOC Baby!

Posted 08 October 2003 - 06:12 PM

umm, .2 of a dollar is not 2 cents it\'s 20 cents.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users