title: PHP: How to include first digit zero on INSERT STATEMENT
body: <p>I'am trying to INSERT number that has first digit of zero</p>
  
  <p>when i try to add prefix <strong>000012345</strong></p>
  
  <p>it will only add <strong>12345</strong></p>
  
  <p>when i try to add prefix <strong>012345</strong></p>
  
  <p>it will only add <strong>12345</strong></p>
  
  <p>my datatype is INT(11)</p>
  
  <pre><code> $sql = "INSERT INTO circle_call_prefixes (circle, prefix)
           VALUES (?,?)";
           $stmt = $dbh-&gt;prepare($sql);
           $stmt -&gt;execute(array($destination , $prefix ));
           $Last_ID = $dbh-&gt;lastInsertId();
           $sql_table2 = "INSERT INTO circle_call_destinations 
           (autoNo,destination, source_circle, comment) VALUES (?,?,?,?)";
           $stmt = $dbh-&gt;prepare($sql_table2);
           $stmt -&gt; execute(array($Last_ID, $destination, $source_circle, $comment));
  </code></pre>
  
  <p>thanks</p>