Thread

I’ve created a template who’s sole purpose is to look up an {entry_id} which varies depending on the channel.

The SQL Query which I’m running is very simple and returns the desired results when run in SequelPro but not when run in a browser.

$author = $this->EE->TMPL->embed_vars['embed:member'];
$channel = ($this->EE->TMPL->embed_vars['embed:datatype']=="member" ? 12 : 15);

$query = "SELECT entry_id FROM exp_channel_titles WHERE channel_id='".$channel."' AND author_id='".$author."'";
$results = $this->EE->db->query($query);

This echo’s out the correct query but returns 0 results.

——
If I hard code the author_id then it returns the desired results:

$query = "SELECT entry_id FROM exp_channel_titles WHERE channel_id='12' AND author_id='25'";
$results = $this->EE->db->query($query);

This echo’s out the the same query as the first one except with the desired result.

Hi Dyad,

I think the issue here is that PHP on input is parsed before embed variables, so your query isn’t being populated with meaningful variables. Have you tried setting PHP to output on your template?

Do you have template debugging turned on? That is really helpful in determining the queries executed as the template is parsed. It can be a clue to parse order issues.

Cheers!

I already tried turning on debugging. The SQL query was correct there as well.

SELECT entry_id FROM exp_channel_titles WHERE channel_id='12' AND author_id='25'

Hi Dyad,

Have you tried switching your template settings to use PHP on Output as Dan suggested? Please try that and then get back to us with the result.

Sean

Yes. I’ve tried that.

Like i said the string i’m passing to $this->EE->db->query(); echo’s out fine.

Hello Dyad,

Is this template an embeded template?

Have you seen ExpressionEngine’s Parse Order by Low?

We use this document a lot around here because parse order is so important.

Because hard-coding the id makes the query works, this really sounds like parse order.

Looking forward to your response.

Cheers,