Mysql And Php Number Inserting Problem

[Mod-Jay]

Hello, i made a text site, so you can text from a website. i was making a database of the texted numbers and i found that the mysql line is not inserting the correct number, its going to the max php one.

 

Here the code:

if (array_key_exists($carrier, $carriers))
{

$correctCarrier = $carriers[$carrier];


$i = 0;
while($i < $_POST['amount']){
$i++;

$formatted_number = $to.$correctCarrier;
$result = ("$i of Your Messages Has been sent to the number ". $_POST['to'] . ".<br>" . mail("$formatted_number", "$subject", "$message") . "");
}
mysql_query("INSERT INTO `msgssent` (`number`, `numberofmsg`, `subject`, `message`) VALUES (". $_POST['to'] .", '". $i ."', '". $subject ."', '". $message ."')") Or die(mysql_error());

Echo $result;
}

[Pikachu2000]

What does "the max php one" mean?

[Mod-Jay]

Max Php number 2147416746...

[Pikachu2000]

I'm guessing you have the data type for the field in the table set to INT, right? Change it to BIGINT, or CHAR(10) for a 10 digit number.