title: Update query in zend framework 2
body: <p>I am using adapter in zend framework 2. My code is for mysql update query which is not working, can any one suggest me. Array result is ok but its not display in query. Just shows update tablename set.</p>
  
  <p>I have tried all suggestions of SO and also from Google, but I am failed to solve that problem. </p>
  
  <p>Code is here:</p>
  
  <pre><code>public function updatebhkdetail($bhkupdate)
  {
      $WHERE = 'project_id='.$bhkupdate['project_id'];
      $sql = new Sql($this-&gt;adapter);
      $update1bhk = $sql-&gt;update('tablename', array($bhkupdate), $WHERE);
      $statementUpdate = $sql-&gt;getSqlStringForSqlObject($update1bhk);
      $sectorName = $this-&gt;adapter-&gt;query($statementUpdate,
                           \Zend\Db\Adapter\Adapter::QUERY_MODE_EXECUTE);
  }
  </code></pre>