[SOLVED] Simple UPDATE query

[completeamateur]

Hi guys,

 

I'm trying to create a simple query to update some records.

 

$this->update(array('lft'=>'lft + 2'), 'lft > ' . $lft);

 

This works fine, except it does not write the correct value in the lft column, it just writes '0', where as it should be 'lft + 2' i.e. the original value + 2.  I'm not quite sure what I'm doing wrong.

 

TIA

[trq]

That code allone doesn't make much sense without context. You should at least inform us what framework / library your using.

[completeamateur]

Apologies, I'm using Zend Framework 1.5

[Daniel0]

Try

$this->update(array('lft'=> new Zend_Db_Expr('lft + 2')), 'lft > ' . $lft);

 

Which class does $this refer to here?

[completeamateur]

Daniel, that's worked a treat.  It was trying to enter it as a string rather than an expression.  Thank you so much.

[Daniel0]

No problem. Remember to click the "Topic Solved" button when you're done. I did it for you this time though