I have a small script that adds a certain amount to a number already in a database. It works fine, until it gets to large numbers, such as 100000000000, where is changes to something like: 1.0000000000e+22.
I am using a `text`column for this, it has to be a `text`, it can't be `int` or other numeric fields.
Does anyone know of any ways around this so it displays the correct number without the e+22 etc?
Thanks,
Someberry.
mySQL number erro.
Moderator: General Moderators
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
you don't necessarily have to install any modules, you just need a library that can perform all the tasks you want on much larger integer sets.
http://php.net/gmp
http://php.net/gmp