PDO perform 2 mysql selects in the same loop
<p>quick question!<br>
how do i perform 2 selects with PDO and run them through the same loop ? <br>
<code>$sql1 = $db-&gt;query("SELECT * FROM produkts");</code><br>
<code>$sql2 = $db-&gt;query("SELECT * FROM buyers");</code><br>
<code>$sql1-&gt;setFetchMode(PDO::FETCH_ASSOC);</code><br>
<code>$sql1-&gt;setFetchMode(PDO::FETCH_ASSOC);</code><br>
<code>while($row = $stmt-&gt;fetch() &amp;&amp; $row1 = $stmt1-&gt;fetch()){</code><br>
<code>Something to be displayed</code><br>
<code>}</code><br>
This obviously doesn't work, and i have no clue how to make it work.
<br>
how is this performed ??</p>
