jumbled number

[mATOK]

hey there

I grab input from a form

<tr><th>Phone</th><td><input type="text" name="phone" size="10" /></td></tr>

and I store it in a db - telnum INT -

but when I retreive the info it's all jumbled and aren't even the numbers I am keying in

e.g. 1234567891 returns 1234567891 but 4164882073 returns 2147483647
any idea as to what could cause this?

[kenrbnsn]

The number 2147483647 is the largest number that can be stored in a 32 byte integer. Change the field type to varchar(10).

Ken

[mATOK]

Thanx! I changed to a double  :)