How to get the returned rows after executing a PHP/MYSQL prepared statement? : <p>I know the output of an execute statement is a bool. But then how do you get the result of a SELECT statement like below?</p>

<pre><code>&lt;?php
/* Execute a prepared statement by passing an array of insert values */
$calories = 150;
$colour = 'red';
$sth = $dbh-&gt;prepare('SELECT name, colour, calories
    FROM fruit
    WHERE calories &lt; :calories AND colour = :colour');
$sth-&gt;execute(array(':calories' =&gt; $calories, ':colour' =&gt; $colour));
?&gt;
</code></pre>

<p>$sth will be either TRUE or FALSE. What I'm interested in is the return rows containing the name, colour and etc.</p>

<p>Thanks!</p>
