title: While loop only displaying first result
body: <p>So, I had this code working earlier today--and all of a sudden it decided to only start displaying the first result from the query. I cannot figure out what i've changed since then, I actually believe that I haven't changed anything... anyway... I've gone into the DB and altered the table so that all the "upgrades" meet the requirements to be displayed, and yet still only one result is being shown. </p>
  
  <pre><code>        $sql = "SELECT id, name, cost, count(*) FROM upgrades 
              WHERE id NOT IN (Select upgrade_id  FROM thehave8_site1.user_upgrades WHERE uid = :uid)
              AND nullif NOT IN(SELECT upgrade_id FROM thehave8_site1.user_upgrades WHERE uid = :uid2)
              AND prereq IN (SELECT upgrade_id FROM thehave8_site1.user_upgrades WHERE uid = :uid3)
              ;";
      $que = $this-&gt;db-&gt;prepare($sql);
      #$que-&gt;bindParam(':id', $id); //note the : before id
      #$que-&gt;bindParam(':id2', $id);
      $que-&gt;bindParam(':uid', $this-&gt;uid);
      $que-&gt;bindParam(':uid2', $this-&gt;uid);
      $que-&gt;bindParam(':uid3', $this-&gt;uid);
      try { 
          $que-&gt;execute();
          while($row = $que-&gt;fetch(PDO::FETCH_BOTH))
          {
  
                  echo "&lt;div class='upgrade' id={$row[0]}&gt;&lt;p&gt;{$row[1]}&lt;/p&gt;&lt;p&gt;{$row[2]}&lt;/p&gt;&lt;/div&gt;";
  
          }
      } catch(PDOException $e) { echo $e-&gt;getMessage();}
  </code></pre>