Reaper0167 Posted July 9, 2009 Share Posted July 9, 2009 in my php script that uploads a four digit number to mysql, I am having problems with any number that starts with '0'. If I upload '0152' and then check my database, it says 152. How can I overcome this? Link to comment https://forums.phpfreaks.com/topic/165285-solved-the-number-0-with-php-and-mysql/ Share on other sites More sharing options...
allenskd Posted July 9, 2009 Share Posted July 9, 2009 You must attribute the column to ZEROFILL in phpmyadmin it would be UNSIGNED ZEROFILL Link to comment https://forums.phpfreaks.com/topic/165285-solved-the-number-0-with-php-and-mysql/#findComment-871640 Share on other sites More sharing options...
Reaper0167 Posted July 9, 2009 Author Share Posted July 9, 2009 Thanks Link to comment https://forums.phpfreaks.com/topic/165285-solved-the-number-0-with-php-and-mysql/#findComment-871645 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.