Zend Framework：如何从数据库表字段中减去金额？

Question

I want to subtract a amount from a table's field in Zend Framework. I can run it with SQL using following query:

UPDATE `Person` SET credit=credit-50 where id=1

But how to write above SQL query in Zend Framework?

Answer 1

$row = array('credit' => new Zend_Db_Expr('credit - 50'));
$where = "id = 1";
$nRowsAffected = $db->update('Person', $row, $where);