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? 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? 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. Link to comment https://forums.phpfreaks.com/topic/100117-inserting-data/#findComment-511922 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.