title: Need help with Zend_db update
body: <p>Currently I'm working with Zend framework and I need help with Zend_db update in Zend_Db_Table_Abstract class.</p>
  
  <p>Here is my SQL statement</p>
  
  <pre><code>UPDATE user
     SET password = '$password',
  `enter code here`  WHERE email = '$email'
  </code></pre>
  
  <p>Here is my code in zend_db</p>
  
  <pre><code>   public function updatePassword($password,$email)
      {
         $data = array(
              'password' =&gt; $password
          );
  
         $where = "email = '". $email ."'";
      $this-&gt;update($data, 'email = '.$email);
  
  
      }
  </code></pre>
  
  <p>This only work if I update using int id as my where clause but I wanted to use a email string as a where clause.</p>
  
  <p>Can someone please help me the best way to achieve this?</p>
  
  <p>I wanted to be secure and avoid SQL Injection attack</p>
  
  <p>Thanks so much in advance.</p>