Perform multiple column query in php
<p>I have a table with 2 entries</p>

<p>Blocker , Blocked</p>

<p>I want to perform following query</p>

<pre><code>$statement = $conn-&gt;prepare('SELECT (blocked FROM blocks WHERE blocker = :myPlayerId) AND (blocker FROM blocks WHERE blocked=:myPlayerId)');
            $statement-&gt;bindParam(':myPlayerId', $myPlayerId, PDO::PARAM_INT);
            $statement-&gt;execute();
</code></pre>

<p>I want to get values in blocked and blocker columns where my id is myPlayerId.</p>
