title: Using SQlite3 in PHP how to count the number of rows in a result set?
body: <p>currently I am using:</p>
  
  <pre><code>$result = new SQLite3(sprintf("users/USERIDS_DB.sqlite"));
  
  $numRows = $result-&gt;exec ("SELECT count(*) FROM USERIDS");
  
  echo sprintf("the number of rows are: %d", $numRows);
  </code></pre>
  
  <p>but the result is 1 when it should be 6 (the number of rows I created using firefox sqlite3 addon)</p>
  
  <p>Can anybody help please?</p>