title: Zend_Db_Table_Abstract count
body: <p>On Zend_Db_Table_Abstract I'm using this code to get the count of results for my select:</p>
  
  <pre><code>$this-&gt;setTableName('visitors');
  $select = $this-&gt;select()
                 -&gt;from('visitors')
                 -&gt;columns(array('total' =&gt; new Zend_Db_Expr('COUNT(*)')))
                 -&gt;where('...');
  $visits = $this-&gt;_fetch($select);
  </code></pre>
  
  <p>Is there a better way, ie, just to return the count. This returns some other data in an array... I just want the count of results. In straight mySQl the equivalent would be <code>select count(</code>mycol<code>) from visitors where ....</code></p>