title: Is there a way to get the number of records from a query with Zend-framework?
body: <p>Given my generic select below, is there a way to get the number of records returned from a query with Zend Framework?  $row++ in a loop is not acceptable for my solution as I am using paging (though its not in my sample).</p>
  
  <p>I also DO NOT want to add another query with "Count(*)".</p>
  
  <pre><code>$query = "Select * from Users where active = 1";
  $stmt = $db-&gt;query($query);
  
  $noOfRows = ???;
  
  while ($row = $stmt-&gt;fetch())
  {
  
    // processing
  }
  </code></pre>