title: mySQL removing leading zeros even with data type set as string
body: <p>I have a mySQL address database and for the zip code column I need mySQL to keep the leading zeros. No matter what I do, the leading zeros are removed from the zip codes. I tried setting the column as both varchar and char thinking the string type would fix the problem, but this is not working. I can manually change the numbers within the database to include the zero, but using PHP to add the zip results in "01234" being changed to "1234".</p>
  
  <p>Any other suggestions? Thanks!</p>
  
  <p>Code:</p>
  
  <pre><code>$input_zip = "01234";
  
  $query_buildzip = "INSERT INTO dir_zipcode(zipcode) VALUES($input_zip)";
  
  $result_buildzip = mysql_query($query_buildzip);
  </code></pre>