Probleem bij getallen van 1E10 (Opgelost)

CREATE TABLE `number_format_test` (
  `geld` bigint(255) NOT NULL,
  `id` int(2) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

CREATE TABLE `number_format_test` (
  `geld` bigint(255) NOT NULL,
  `id` int(2) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

<?php
mysql_connect('localhost','gebruikertje','wachtwoordje');
mysql_select_db('testDB');

$getal = 1000000000000;

$formatted = number_format($getal,0,'','');
echo $formatted;

echo "<br><hr><br>";

$select = mysql_query('SELECT * FROM `number_format_test`') or die ("Fout in SELECT: " . mysql_error());

if(mysql_num_rows($select) == 0) {
	mysql_query("INSERT INTO `number_format_test` (geld) VALUES ('" . $formatted . "')") or die ("Fout in INSERT: " . mysql_error());
	$type = 'INSERT';
}
else {
	mysql_query("UPDATE `number_format_test` SET `geld`='" . $formatted . "' WHERE `id`='1'") or die ("Fout in UPDATE: " . mysql_error());
	$type = 'UPDATE';
}

$fetch = mysql_fetch_assoc($select);
echo $type . ": " . $fetch['geld'];
?>

<?php
mysql_connect('localhost','gebruikertje','wachtwoordje');
mysql_select_db('testDB');
 
$getal = 1000000000000;
 
$formatted = number_format($getal,0,'','');
echo $formatted;
 
echo "<br><hr><br>";
 
$select = mysql_query('SELECT * FROM `number_format_test`') or die ("Fout in SELECT: " . mysql_error());
 
if(mysql_num_rows($select) == 0) {
	mysql_query("INSERT INTO `number_format_test` (geld) VALUES ('" . $formatted . "')") or die ("Fout in INSERT: " . mysql_error());
	$type = 'INSERT';
}
else {
	mysql_query("UPDATE `number_format_test` SET `geld`='" . $formatted . "' WHERE `id`='1'") or die ("Fout in UPDATE: " . mysql_error());
	$type = 'UPDATE';
}
 
$fetch = mysql_fetch_assoc($select);
echo $type . ": " . $fetch['geld'];
?>