[SOLVED] Simple UPDATE query

[completeamateur]

Hi guys,

 

I'm trying to increment the current value of a column by using an update query.

 

UPDATE category SET lft = lft + 2 WHERE lft > $lft;

 

Unfortunately, because I'm using Zend Framework, it interprets 'lft + 2' incorrectly (don't ask me why!).  Is there another way to increment the existing value, e.g. lft++

 

[Mchl]

What is the actual PHP code you use?

 

Maybe you should try

UPDATE category SET `lft` = `lft` + 2 WHERE `lft` > $lft;

[/code]

[completeamateur]

I'm working with ZF so the code I use to generate the query is a little abstract...

 

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

 

I've tried all variations of apostrophes and quotes but to no avail.  Interestingly enough, I've found that...

 

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

 

...works fine, but...

 

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

 

...doesn't.  I presume this is because it is trying to enter the string 'lft'?

[Mchl]

Try

echo $this->update->__toString();

 

this should echo the actual query string, so that you can check the syntax.

[completeamateur]

I'm afraid this just returns...

 

Notice: Undefined property: Catalogue::$update in /Library/WebServer/Documents/bbusl/application/models/Catalogue.php on line 80

 

Fatal error: Call to a member function __toString() on a non-object in /Library/WebServer/Documents/bbusl/application/models/Catalogue.php on line 80

[completeamateur]

Yippee!... this has been solved in a different thread!

 

http://www.phpfreaks.com/forums/index.php/topic,227860.0.html

[Mchl]

Cool. I must take a note of this. I'm just struggling with ZF myself.

[fenway]

Yippee!... this has been solved in a different thread!

 

http://www.phpfreaks.com/forums/index.php/topic,227860.0.html

Then you've double-posted... careful now.