Re: [fw-db] How to Increment a field by 1 using Update()

Anees wrote:
>
> i need to increment one of my field value by 1 using the update ()
>

$table = 'products';
$data = array('prd_qnty' => new Zend_Db_Expr('prd_qnty + 1'));
$where[] = $db->quoteInto('pr_id = ?', $this->pr_id);
$db->update($table, $data, $where);

Regards,
Bill Karwin
--
View this message in context: http://www.nabble.com/How-to-Increment-a-field-by-1-using-Update%28%29-tp19161309p19166023.html
Sent from the Zend DB mailing list archive at Nabble.com.