title: SQLite3::open using PHP selecting all rows?
body: <p>How can I select all rows using SQLite3::open? The following code only outputs one row.</p>
  
  <pre><code>&lt;?php
  
      /**
       * Simple example of extending the SQLite3 class and changing the __construct
       * parameters, then using the open method to initialize the DB.
       */
  
      class MyDB extends SQLite3
      {
          function __construct()
          {
              $this-&gt;open('db_backups/database_123456789.db');
          }
      }
  
      $db = new MyDB();
  
      $result = $db-&gt;query('SELECT * FROM myBookmarks');
      var_dump($result-&gt;fetchArray());
      // ONLY DUMPS ONE RESULT
      ?&gt;
  </code></pre>
  
  <p>I got my starting code here.
  <a href="http://www.php.net/manual/en/sqlite3.open.php" rel="nofollow">http://www.php.net/manual/en/sqlite3.open.php</a>   </p>