Hello

How can i make an update that has following Sql:
UPDATE app_user SET expiration = DATE_ADD(IF(expiration IS NOT NULL,
expiration ,now()),INTERVAL 1 MONTH) WHERE id =13

Because the ordinary update method is not working :(:

$aUpdateData = array('expiration' => 'DATE_ADD(IF(expiration IS NOT NULL,
expiration ,now()),INTERVAL 1 MONTH)');
                                                $Affected = 
$oUser->update($aUpdateData, 'id =
'.$this->_getParam('user_id'));
-- 
View this message in context: 
http://www.nabble.com/Problems-with-Zend_Db_Table-tp17048100p17048100.html
Sent from the Zend Framework mailing list archive at Nabble.com.

Reply via email to