SQL Zend-framework update statement

Question

What's wrong with this statement? An error is occurring, it is not reading the second line

(($var = array('tab.order' => 'tab.order+1');)) 

$db->update('tab', $form->getValues(), array('id =?' => $id));
                        $var = array('tab.order' => 'tab.order+1');
                        $var2 = array('tab.order >= ' . $form->getValue('order'));
                        $db->update('tab', $var, $var2);

no error it just doesn't do what i wanted to do which is updating all the rows in the order attribute — haider
– haider, Commented Mar 29, 2011 at 14:15
What do you mean by 'it is not readying the second line'? $var does not exist, does not have the value you expect, etc? — Glen Solsberry
– Glen Solsberry, Commented Mar 29, 2011 at 17:30

Glen Solsberry · Accepted Answer · 2011-03-29 17:32:07Z

1

Your problem is likely happening when Zend_Db does it's escaping of values in $var, and the value becomes

`tab.order+1`

You'll need to do

$var = array('tab.order' => new Zend_Db_Expr('tab.order + 1'));

to get around this.

answered Mar 29, 2011 at 17:32

Glen Solsberry

12.4k16 gold badges74 silver badges96 bronze badges

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

Collectives™ on Stack Overflow

SQL Zend-framework update statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related