hostfreak Posted August 8, 2007 Share Posted August 8, 2007 I have a form that submits Work Codes into a field named: Work_Code. The field is an INT data type. My problem is, say someone tries to enter: "022" for the Work Code. It will store as "22". I am not sure how to fix this, whether it be just the data type or something to do with my php code. Thanks in advanced. Link to comment https://forums.phpfreaks.com/topic/63882-solved-int-datatype/ Share on other sites More sharing options...
hostfreak Posted August 8, 2007 Author Share Posted August 8, 2007 Problem solved. Just in case anyone else comes across this problem, the field must have the attribute: UNSIGNED ZEROFILL Link to comment https://forums.phpfreaks.com/topic/63882-solved-int-datatype/#findComment-318513 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.