title: Error when submitting Warning: PDOStatement::execute(): SQLSTATE[HY093]
body: <p>Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens</p>
  
  <p>Good day, I have been looking at this for hours and I just can not find the problem any help why i keep getting this error would help. </p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>if(isset($_POST['update']))
  {
   $data = getPosts();
    if(empty($data[0]) || empty($data[1]) || empty($data[2]) || empty($data[3]))
    {
     echo 'Enter player id number to update';
    } else {
      $updateStmt = $statement = $db-&gt;prepare('UPDATE players SET Id_num = :idnum, Name = :name, Surname = :sunrame, Club = :club WHERE Id_num = :idnum');
      $updateStmt-&gt;execute(array(
         ':idnum' =&gt;$data[0],
                                                          ':name' =&gt;$data[1],
                                                          ':surname' =&gt;$data[2],
                                                          ':club' =&gt;$data[3]
      ));
      if($updateStmt)
      
      {
      
                                    
       echo 'Player updated successfully';
                                     
                                  }
     }
  }</code></pre>
  </div>
  </div>
  </p>