How to use Zend DB to add value to existing value in table

Question

I would like to do the follow query in Zend DB style. Basically i want to add 1000 to the value in my table where id = 1.

mysql_query("UPDATE `some_table` SET `value` = `value` + 1000 WHERE `id` = 1");

This is my Zend query, but it does not work

$data= array('value' => 'value'+1000);
$this->dbo->update('some_table', $data, $this->dbo->quoteInto('id = ?','1'));

Advice appreciated.

drew010 · Accepted Answer · 2012-08-03 22:05:10Z

8

Try this:

$data = array('value' => new Zend_Db_Expr('value + 1000'));
$this->dbo->update('some_table', $data, $this->dbo->quoteInto('id = ?', 1);

You need to use Zend_Db_Expr so that Zend_Db doesn't try to quote that value or apply any transformations to it.

answered Aug 3, 2012 at 21:54

drew010

70.3k11 gold badges144 silver badges174 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1