CB Auto Action - Capture Query (Select) Return

Hi, I quick question of how to capture the returned results from an Auto Action of Type Query.

I have a 'Select' which simply returns some data, how do I capture these results, see attached image for more details.

So in my 'Action' tab I have a series of SQLs, the first is a Select statement, how do I access the returned results from this?

$var = SELECT * FROM..........

UPDATE TABLE SET VALUE = '$var' WHERE user_id = user_id

I think I've read all available documentation on this, nothing seems to answer my question.

Thanks

A query action just takes your SQL and executes it. The only special behavior that's different from directly writing SQL in phpmyadmin is #__ replacement. You can't use PHP inside of SQL. To do what you're wanting you need to use a subquery or a join. Example as follows.


As for output it's not going to be able to output anything. You're acting on a trigger that's fired during a user update process. It's not possible to output anything during that trigger. As for the URL not working under Global please read its description carefully as it states directly it will not work unless Triggers is set to None.

This makes sense. Thank you.