What I am trying to do is when a customer(customer_id) orders ( zap triggers on new mysql row-custom query) I want to grab information and pass (update row) in a another table in my database. (i thought I would be able to do it with a custom query, but apparently that is not an option). The problem is there are only 2 options for updating a row. My question is what is it updating with? I want to update the p_pic column with {banner_bear_url} where p_id is = to the p_id I pulled in the first query. Thank you for any help you can lend.
