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. Quote Link to comment 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 Quote Link to comment 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.