Hi,
I want to update a set of records to increase some columns value.
I tried this:
$command = Yii::app()->db->createCommand();
$command->update('file',array('rgt'=>rgt+2),array('rgt'>=$_POST['File']['rgt']));
but there is a problem using this expression: ‘rgt’=>rgt+2, errors: Use of undefined constant rgt,
can anybody suggest how I could compose this query?
many thanks.