What are my options for using PHP in a {exp:query} tag?

Hi everyone,

I’m trying to use some php in my query tag in order to qualify and filter what will go in the WHERE clause to customize the output.

I’m running into the problem of conflicting php parse orders though.

While the query tag requires that php be set to ‘input’, the rest of my php code needs to be on ‘output’ in order to utilize data from exp tags (which the query tag needs to use also).

Anyone had any trouble with this before? Do I need to combine multiple sql queries into one in order to avoid using php in the query?

Thanks for the help!

Brian