Hi

I need to do a query to retrieve the entry_id and weblog_id based on the title which comes from a loop and is stored in a php variable.

The query does not return any results, what I am doing wrong????

here is my code:

Thanks in advance

Make sure php is being parsed on input- it needs to be for the above to work.  To see what’s really going on, might turn ‘Show queries’ on in ‘Admin- System Prefs- Output and debug’.

And when I’m doing something like this- I start by hard coding it- make sure it will work.

Lastly- I wouldn’t loop it like this.  I’d take the query out of the loop, hard code a single query that would work: WHERE title IN (‘x’, ‘y’, ‘z’)- though instead of using titles, I’d try passing entry_ids instead.  Anyway ssee if you can hard code it to work w/a single query.  Then format your variables to match the hard coded bit- echo that and run the query once.

Debug the script by echo:ing $relation and see if that is what’s causing the problem.

$relation is ok, the loop gives the expected result but the query does not retrieve the right information, even when I put it outside the loop.

{exp:query sql=“SELECT entry_id, weblog_id, title FROM exp_weblog_titles WHERE title=‘My title’”}
<li><a href=”{path=”>{title}</a></li>
{/exp:query}

I get a different weblog id and title and not the one that refers to the query

You know you could do all that query:ing with a weblog:entries tag?

And btw, I couldn’t help but notice that you’ve missed a closing curly bracket after the path= thing.

Thank you,

I tried a weblog:entries before, but it didn’t work. Something like this:

{exp:weblog:entries}
{if title ==“My entry”}

<li><a href=”{path=”>{title}</a></li>
{/if}
{/exp:weblog:entries}

But it does not work. Outside the loop I don’t get any results and inside the loop I get the same entry repeated several times.I guess it is looping over all the entries.

Also, category_id is not there.

It may be simple but still, I don’t see the way to do it.

Thanks