title: How to fetch a Zend model using a field
body: <p><strong>I have a database table that looks like this:</strong></p>
  
  <pre><code>  CREATE TABLE IF NOT EXISTS `articles` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `texte` varchar(255) NOT NULL,  
    `rubrique` varchar(255) NOT NULL,
    PRIMARY KEY (id)
  );
  </code></pre>
  
  <p><strong>Which is PDO mapped like this:</strong></p>
  
  <pre><code>class Application_Model_DbTable_Articles extends Zend_Db_Table_Abstract
  {
      protected $_name = 'articles';
  
     //this is where I have a problem 
     public function getArticleByRubrique($rubrique) 
      {        
          $row = $this-&gt;fetchRow('rubrique = ' . $rubrique);    
          return $row-&gt;toArray();    
      }  
  
  }
  </code></pre>
  
  <p><strong>In my view I want to fetch the <code>articles</code> that have field <code>rubrique == "club"</code> :</strong></p>
  
  <p>To fetch all the items, this code works fine using <code>fetchAll()</code>:</p>
  
  <pre><code>$articles = new Application_Model_DbTable_Articles();
          $this-&gt;view-&gt;articles = $articles-&gt;fetchAll();
  </code></pre>
  
  <p>But when I do it with <code>getArticleByRubrique()</code> I get this error:</p>
  
  <blockquote>
    <p>SQLSTATE[42S22]: Column not found:
    1054 Unknown column 'club' in 'where
    clause'</p>
  </blockquote>