mysql collection problem

[gene02]

we someone fills out the form on my website the information is sent to me in a email by coldfusion and it comes in correct format but somehow as it is placed in database I only get 3 digits I want it to store like this 000-000-0000 I'm not sure what I am doing wrong
I use tinyint field=contact_munber default=this is blank and NULL
any ideas?

[mushroom]

I use tinyint field=contact_munber default=this is blank and NULL
any ideas?

"tinyint" allowed values 0-255 or -127 to +127.

Use INT (13) or CHAR (15) if you want to store the " - ".

[gene02]

thanks I new I hard the part done sometimes you just can't see the simple stuff