[Typo3-dev] exec_UPDATEquery question.

Stig N. Jepsen stig at 8620.dk
Wed Jul 7 18:25:08 CEST 2004


> I have a problem using exec_UPDATEquery with a specific update.
>
> In theory I want to do something like this:
> UPDATE persondata SET age=age+1;
> Also described here:
> http://www.mysqlfreaks.com/mysql/manual_Reference.html#UPDATE
>
> But when using exec_UPDATEquery it seems like the only way is to supply
data
> from PHP, but not manipulating data in the table itself (only
overwriting).
> F.x. if I supply a dataset like this array("age"=>"age+1") I think it
tries
> to put in the string age+1 instead of adding 1 to the value of age.
> Am I correct in this?

Now instead I'm using sql_query().
Don't know if this is the way to go.

/Stig






More information about the TYPO3-dev mailing list