title: This PDO::FETCH_ASSOC` query skips the 1rst result that's returned
body: <p>I'm transitioning over to PDO prepared statements, and I'm having trouble with the syntax for a basic <code>SELECT</code> query with a <code>WHILE</code> statement.</p>
  
  <p>The <code>foreach</code> statement below echos the correct results, but the <code>PDO::FETCH_ASSOC</code> query is skipping the 1rst result that's returned (so it always echo's one result less than it should). </p>
  
  <p><strong>PDO::FETCH_ASSOC</strong></p>
  
  <pre><code>$stmt = $conn-&gt;prepare("SELECT * FROM products"); 
  $stmt-&gt;execute();
  $row = $stmt-&gt;fetch();
  while($row = $stmt-&gt;fetch(PDO::FETCH_ASSOC)) { 
      echo $row['product_name'].' '.$row['price'].' '.$row['color'], "&lt;br /&gt;"; 
  }
  </code></pre>
  
  <p><strong>foreach</strong></p>
  
  <pre><code>foreach($conn-&gt;query('SELECT * FROM products') as $row) {
      echo $row['product_name'].' '.$row['price'].' '.$row['color'], "&lt;br /&gt;";  
  }
  </code></pre>