[SOLVED] php numbers issue

[EchoFool]

I am trying to insert a value of :

12,020,000,000

 

And the field format is  int(15)

 

Yet when ever i put the number in it limits to :

2,147,483,647

 

My script is simple:

<?php
//happy max comes from a query further up
$Price = $HappyMax * 119.6;
Echo $Price;
$Update = mysql_query("UPDATE househappy SET Price = '$Price' WHERE RecordID='$RecordID'")
Or die(mysql_error()); 
?>

 

When i echo price i get this:

12020000000

 

But database shows:

2147483647

 

Why is this?

[DarkWater]

The max that an INT can hold is 2,147,483,647, or 2^31 (on 32-bit systems, signed.  64-bit systems hold way more.)

[EchoFool]

So it will have to be a string type for field ?

[wildteen88]

So it will have to be a string type for field ?

No, MySQL has another INT dataype which is BIGINT. This can hold a much larger number (-9223372036854775808 to 9223372036854775807)

[DarkWater]

Try BIGINT.  It holds 92,23,372,036,854,775,807.  Just enough. xD

 

EDIT: wildteen beat me to it.  *sob*

[EchoFool]

Thanks for the info