title: LIMIT keyword on MySQL with prepared statement
body: <pre><code>SELECT id, content, date
  FROM comment
  WHERE post = ?
  ORDER BY date DESC
  LIMIT ?, ?
  </code></pre>
  
  <p>With PDO (I'm using MAMP 2.0.5 that has Apache 2.2.21, PHP up to 5.3.6, and MySQL 5.5.9) prepared statement this doesn't work, if I change the query with</p>
  
  <pre><code>LIMIT 0, 10
  </code></pre>
  
  <p>it works.</p>
  
  <p>I see in the bugs of MySQL that this was a bug in previous version but I can't understand if this is still to be fixed.</p>
  
  <p>If this is still a problem, there is a way to select a range of rows in another way?</p>
  
  <p>code:</p>
  
  <pre><code>$comments = $db-&gt;prepare($query); 
  /* where $db is the PDO object */ 
  $comments-&gt;execute(array($post, $min, $max)); 
  </code></pre>