sasori Posted September 6, 2008 Share Posted September 6, 2008 Help. I inserted a phone number in my table, but the result changes i don't know what's going on. kindly help me what to do. here's the screenshot Link to comment https://forums.phpfreaks.com/topic/122978-solved-inserted-data-changed-help/ Share on other sites More sharing options...
PFMaBiSmAd Posted September 6, 2008 Share Posted September 6, 2008 A phone number is not an integer, it is a formatted string of digits. Use a varchar column to hold them. Link to comment https://forums.phpfreaks.com/topic/122978-solved-inserted-data-changed-help/#findComment-635077 Share on other sites More sharing options...
sasori Posted September 6, 2008 Author Share Posted September 6, 2008 A phone number is not an integer, it is a formatted string of digits. Use a varchar column to hold them. ok done ALTER TABLE `phone` CHANGE `phonenumber` `phonenumber` VARCHAR( 15 ) NULL DEFAULT NULL case solved Link to comment https://forums.phpfreaks.com/topic/122978-solved-inserted-data-changed-help/#findComment-635078 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.