PHP: How to include first digit zero on INSERT STATEMENT
<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>