title: Insert value list does not match column list: 1136 Column count doesn't match value count
body: <p>I have this PHP-MySQL insert code:</p>
  
  <pre><code>$sqlTeeth = "INSERT INTO teeth (id_logged, patient_id, one, two, three, four, five, six, seven, eight, nine, ten, eleven, twelve, thirteen, fourteen, fifteen, sixteen, seventeen, eightteen, nineteen, twenty, twone, twtwo, twthree, twfour, twfive, twsix, twseven, tweight, twnine, thirty, thone, thtwo, date_now) VALUES (:id_logged, :patient_id, :one, :two, :three, :four, :five, :six, :seven, :eight, :nine, :ten, :eleven, :twelve, :thirteen,
              :fourteen, :fifteen, :sixteen, :lone, :ltwo, :lthree, :lfour, :lfive, :lsix, :lseven, :leight, :lnine, :lten, :leleven, :ltwelve, :lthirteen,
              :lfourteen, :lfifteen, :lsixteen)";
          $sqlTeethStmt = $conn-&gt;prepare($sqlTeeth);
          $sqlTeethStmt-&gt;bindValue(":id_logged", $id_logged);
          $sqlTeethStmt-&gt;bindValue(":patient_id", $patient_id);
          $sqlTeethStmt-&gt;bindValue(":one", $one);
          $sqlTeethStmt-&gt;bindValue(":two", $two);
          $sqlTeethStmt-&gt;bindValue(":three", $three);
          $sqlTeethStmt-&gt;bindValue(":four", $four);
          $sqlTeethStmt-&gt;bindValue(":five", $five);
          $sqlTeethStmt-&gt;bindValue(":six", $six);
          $sqlTeethStmt-&gt;bindValue(":seven", $seven);
          $sqlTeethStmt-&gt;bindValue(":eight", $eight);
          $sqlTeethStmt-&gt;bindValue(":nine", $nine);
          $sqlTeethStmt-&gt;bindValue(":ten", $ten);
          $sqlTeethStmt-&gt;bindValue(":eleven", $eleven);
          $sqlTeethStmt-&gt;bindValue(":twelve", $twelve);
          $sqlTeethStmt-&gt;bindValue(":thirteen", $thirteen);
          $sqlTeethStmt-&gt;bindValue(":fourteen", $fourteen);
          $sqlTeethStmt-&gt;bindValue(":fifteen", $fifteen);
          $sqlTeethStmt-&gt;bindValue(":sixteen", $sixteen);
  
          $sqlTeethStmt-&gt;bindValue(":lone", $lone);
          $sqlTeethStmt-&gt;bindValue(":ltwo", $ltwo);
          $sqlTeethStmt-&gt;bindValue(":lthree", $lthree);
          $sqlTeethStmt-&gt;bindValue(":lfour", $lfour);
          $sqlTeethStmt-&gt;bindValue(":lfive", $lfive);
          $sqlTeethStmt-&gt;bindValue(":lsix", $lsix);
          $sqlTeethStmt-&gt;bindValue(":lseven", $lseven);
          $sqlTeethStmt-&gt;bindValue(":leight", $leight);
          $sqlTeethStmt-&gt;bindValue(":lnine", $lnine);
          $sqlTeethStmt-&gt;bindValue(":lten", $lten);
          $sqlTeethStmt-&gt;bindValue(":leleven", $leleven);
          $sqlTeethStmt-&gt;bindValue(":ltwelve", $ltwelve);
          $sqlTeethStmt-&gt;bindValue(":lthirteen", $lthirteen);
          $sqlTeethStmt-&gt;bindValue(":lfourteen", $lfourteen);
          $sqlTeethStmt-&gt;bindValue(":lfifteen", $lfifteen);
          $sqlTeethStmt-&gt;bindValue(":lsixteen", $lsixteen);
  
          $sqlTeethStmt-&gt;execute();
  </code></pre>
  
  <p>When I add something to database, I got this error:</p>
  
  <blockquote>
    <p>SQLSTATE[21S01]: Insert value list does not match column list: 1136
    Column count doesn't match value count at row 1</p>
  </blockquote>
  
  <p>Any Help is appreciated.</p>