title: Zend Framework - Update a Database row with WHERE and AND
body: <p>To use <code>where</code> in a MySQL table row update in Zend Framework I have something like:</p>
  
  <pre><code>public function updateBySiteId(array $data, $id) {
          $table = $this-&gt;gettable();
  
          $where = $table-&gt;getAdapter()-&gt;quoteInto('site_id = ?', $id);
  
          return $table-&gt;update($data, $where);
      }
  </code></pre>
  
  <p>and this, I expect, gives me something like...</p>
  
  <pre><code>UPDATE foo SET ponies = 'sparkly' WHERE site_id = '1'
  </code></pre>
  
  <p>But what if I want to create the following:</p>
  
  <pre><code>UPDATE foo SET ponies = 'sparkly' WHERE site_id = '1' AND type = 'zombie'
  </code></pre>
  
  <p>In the manual I don't see how to do this with quoteInto (or quote or some other safe method... which could just mean I'm looking in the wrong place but... <em>sigh</em>).</p>