westminster86 Posted April 8, 2008 Share Posted April 8, 2008 Im having trouble inserting a telephone number into a table. For some reason its taking off the 0 at the beginning of the number. Why is this? Quote Link to comment https://forums.phpfreaks.com/topic/100117-inserting-data/ Share on other sites More sharing options...
zenag Posted April 8, 2008 Share Posted April 8, 2008 can u show ur ur database structure? Quote Link to comment https://forums.phpfreaks.com/topic/100117-inserting-data/#findComment-511912 Share on other sites More sharing options...
friedemann_bach Posted April 8, 2008 Share Posted April 8, 2008 I guess the phone number field in your database is an INTEGER field that omits leading zeros (00394567123 becomes 394567123). Phone numbers should be treated as strings - use VARCHAR instead of integer. Quote Link to comment https://forums.phpfreaks.com/topic/100117-inserting-data/#findComment-511922 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.