PHP / MYSQL issue with BIGINT

Question

I have a mysql database and a table to store information from the twitter API. When I parse data from PHP from twitter, I use mysql_query to insert data into a table.

I have a strange problem with the tweet id:

For example, a status update with the identifier 15861323074113537 (tweet from google) is stored in the database as: 15861323074114000 (last 4 digits changed).

Php request:

$sql = mysql_query("INSERT INTO $table (id,tw_text) VALUES ($id,'$tw_text')");

If I edit the entry via phpmyadmin, the correct value will be saved (15861323074113537). Column BIGINT.

So, I think something strange is happening with the mysql_query php function and the INSERT command.

Any ideas / solutions?

Thanks in advance

Answer 1

ok , . Twitter 2 , 000 . [id_str] = > 15861323074113537 [id] = > 15861323074114000

twitter API!

:/

Answer 2

PHP . , , float. , , float , . webbiedave , .