Large Integers

[Millar]

I have a sum which ends up returning a float because basically it results in larger than 2 billion. I want to insert the value that is larger than 2 billion into a bigint field in a MySQL table, how can I insert it into the field because if you inser the float it simply returns 0 and if I inster it as an integer it just does the maximum of 2147483647?

[ToonMariner]

????

big int should manage a 20 digit number no probs

[Millar]

Yes, it does, but PHP can't handle the Number when it is in Integer form, and I need to get it into maybe an equivilent of bigint in PHP to put it into the MySQL database, I can't use a float because that will return zero when you try and insert into database.

[heckenschutze]

Well, Possibly insert it as a string... :)

[Millar]

But that would mean having to change the database field to a string aswell, I can't do that because then I would be able to order it in Ascending and Descending order will I?

[Skatecrazy1]

no, it wouldn't mean having to change the database field as a string....
it's simple, just make it a string in PHP, say a variable, then just put the variable into  your INSERT INTO query

[heckenschutze]

Does't matter, MySQL can still order by string...

eg

1.6e7

is larger than

1.7e7

So you WILL get expected results. Provided you use this notation for all numbers, regardless of value.