Incorrect Integer (2147483647) is inserted into MySQL?
insert, mysql, php, steam-web-api
Solution
Based on your comment of "value being dumped"; the number you are trying to insert is too large for 32-bit systems. The max for 32-bit is 4,294,967,295, and the max for 64-bit is 18,446,744,073,709,551,615. I'd recommend converting your column into a `varchar(100)` hash rather than an int, or switch to a 64 bit system. Great article about max ints here, and here.
Also, before I get flamed, be sure to read up on SQL injection in case you are not sanitizing variables being posted directly into sql statements.
Problem
Alright, so I've been toying around with the Steam Web API, I have one of the values stored in a variable called `$steam64`. When I use this code snipper to INSERT it into a mysql database it insert a completley different integer than what is stored in the variable. `$sql_query = "INSERT INTO users_info (steam64) VALUES ('$steam64')";` `var_dump($steam64);` returns the real int, so does echoing it. Not too sure what is going on here, any help is appreciated.