Query Field: Update another field

Hi all,

I have the following Query Field set up:

What I am trying to achieve is the following:

Calculate price based on 'cb_2016_pzo_membership_paid'. If 'cb_2016_pzo_membership_paid ' = 1 then update 'membership_price' to 107,59 if 'cb_2016_pzo_membership_paid ' = 0 then update 'membership_price' to '72,50'

How to do this?

You don't need a query field for that. A simple IF substitution usage should work fine. Example as follows.

[cb:if cb_2016_pzo_membership_paid="1"]107,59[/cb:if][cb:if cb_2016_pzo_membership_paid!="1"]72,50[/cb:if]

If you still want to use a query then I suggest just doing a simple select with an IF function usage in the select. See the below MYSQL documentation.

dev.mysql.com/doc/refman/5.6/en/control-flow-functions.html#function_if

Thanks for the reply, leaves me with the following question: What kind of field should I use for that then?

Depends on where you're doing this as you may not even need a field, but for a substitution only field you'd use a Custom HTML fieldtype.