Thread

How do you do this?

I’ve tried the following

{exp:query sql="SELECT cat_id FROM exp_category_posts WHERE entry_id = '{entry_id}' "}
   {exp:query sql="SELECT cat_name FROM exp_categories WHERE cat_id='{cat_id}' "}
      {cat_name}
   {/exp:query}
{/exp:query}

It returns the correct {cat_id} (which there are four entries) values but when {cat_id} is used to fetch the cat_name it just returns the first {cat_name} four times.

Any Ideas?

Instead of all that, have you tried:

{categories}
{category_name}
{/categories}

If that doesn’t work, post the whole template if you can. I’m not sure a query within a query will work the way you want it to which is probably why your getting repeated data.

wow was I way over thinking it. Thanks for the reply it worked beautifully. good to know for future reference that nested query’s don’t work though.

Thanks again, much appreciated.

No problem, we’ve all been there. Glad I could help.  😉