title: PDO Updatequery changes id without asking?
body: <p>im having a little problem with an UPDATE query run via PDO.
  This is the part where im having an issue with:</p>
  
  <pre><code>$query="UPDATE snippets SET snippet= ? WHERE id= ?";
  $query=$pdo-&gt;prepare($query);
  $query-&gt;execute([ $_POST['snippet'] , $_POST['id'] ]);
  </code></pre>
  
  <p>it works, as in it changes the snippet to what it is supposed to, but for some reason the id of the affected column also changes (counting up).
  The id is set as AUTO_INCREMENT on the SQL-Server but as far as i know that should only aply to new columns, not updates.
  If i run the exact same query using a thrid party tool it doesnt change the id, just the snippet value. I've tried it out with HeidiSQL and phpMyAdmin.</p>
  
  <p>Any insight into why this happens is much appreciated</p>