zend framework update problem(update multiple rows)

Question

i want to update multiple rows in DB using Zend Framework(Zend_db). i want to add 2 to one field of each row what should i use? im a beginner to ZF.

Answer 1

$row = array('theColumnName' => new Zend_Db_Expr('theColumnName + 2'));
$where = "id > 50"; 
// leave out the $where parameter to update all rows.
$nRowsUpdated = $db->update('tableName', $row, $where);

if you have multiple where conditions, you can do this:

$where = array();
$where[] = "foo = something";
$where[] = "id > something";

You should read the Zend_Db reference guide, which has plenty of examples.