title: PHP/PDO: use simple prepared statement with query return/affected rows?
body: <p>I am new to PDO objects and cannot find a single piece of documentation that will help me. Say I got a simple code to delete a row:</p>
  
  <pre><code>$count = $dbh-&gt;exec("DELETE FROM fruit WHERE colour = 'red'");
  </code></pre>
  
  <p>That will return affected rows, but how would I use prepared statements with that? Can use use <code>$dbh-&gt;prepare</code> AND <code>$dbh-&gt;exec</code> or query !?</p>