title: How do I fetch mulitiple rows using fetch(PDO::FETCH_ASSOC) with pdo?
body: <p>testQuery() is the method I use to get all rows from table CATEGORIES</p>
  
  <pre><code>public function __construct()
   {
   self::$tdb = Database::getConnection();
   }
  
  
  
   #mock query to pull results from db
   public function testQuery()
    {
         $queryAA = "SELECT cat_name, cat_description, cat_id FROM CATEGORIES";
         $stmtAA = self::$tdb-&gt;prepare($queryAA);
  
  
         if ($stmtAA-&gt;execute() == true)
          {
               print("Execution was successful");
               return $stmtAA-&gt;fetch(PDO::FETCH_ASSOC);   
          }
         else
          {
              print("Warning statment did not successfully execute");
          }
       }
  </code></pre>
  
  <p>I normally use fetchAll() but I was told to use fetch as it doesn't take up as much memory.
  But I am having trouble retrieving more than one row using fetch() and the code below.</p>
  
  <pre><code>$test = new test();
  $results = $test-&gt;testQuery();
  
  
  foreach ($results as $row)
   {
   print_r($row);
   }
  </code></pre>
  
  <p>It only fetches 1 row. So how do I retrieve and print multiple rows? Using iteration was mentioned before but I'm not sure to implement it. Any help would greatly be appreciated. Thanks! </p>