phone number field in MySQL


	Cow Forums : Adobe Dreamweaver << PREVIOUS THREAD • VIEW ALL THREADS • PRINT • NEXT THREAD >>

phone number field in MySQL
by Neil Bradley on Jul 10, 2008 at 7:07:46 pm

Hey all,
I have a data base that collects info from users via a registration page.
Only problem is the phone number field does not display the users entire phone number in the data base after it has been entered. At best it only displays 1 digit.

My setting for the phone field are as follows.
Field: phone type Varchar(20) Null: No

Any suggestion?

Cheers,
Neil

Respond to this post • Return to posts index

Re: phone number field in MySQL
by Abraham Chaffin on Jul 15, 2008 at 8:02:15 pm

Varchar(20) should allow you to enter a full phone number. The problem probably lies somewhere else in your coding. You might post the other portions of code that are responsible for putting the data into the MySQL table. Starting with the form and into the MySQL INSERT or UPDATE line.

Abraham

Respond to this post • Return to posts index


	<< PREVIOUS THREAD • VIEW ALL THREADS • PRINT • NEXT THREAD >>