Thread

Hi all. Is it possible to reverse the output of either the {categories} or the {exp:channel:categories}.

I’m building my meta page <title> on a single entry page and I need to output the parent and child categories in reverse, so I end up with this format…

title | child category | parent category | template group | site name

But since those tags output parent then child and seem to have no sort option I’m stumped!

Thanks

Hi Mike,

You can always use a query to get what you want.
Assuming your child categories have only 1 parent category (the parent category is a root category), you can use this to get the parent category for an entry:

{exp:query sql="SELECT cat_name AS parent_name, cat_url_title AS parent_cat_url_title FROM exp_categories c, exp_category_posts cp WHERE c.cat_id=cp.cat_id AND c.parent_id=0 AND cp.entry_id={entry_id}"}<a href="http://{parent_cat_url}">{parent_cat}</a>{/exp:query}

And, to get your child category, assuming your entry has only been added to 1 child category, you can use this:

{categories}
{if parent_id != 0}
<a href="http://{category_url_title}">{category_name}</a>
{/if}
{/categories}

Hope that helps!

Hi Leon,

The query didn’t output anything, the parent is the root category too. The child category worked great though.

Cheers
Mike

Hi Mike,

Woops sorry, I messed up the names there.

Try this instead:

{exp:query sql="SELECT cat_name AS parent_name, cat_url_title AS parent_cat_url_title FROM exp_categories c, exp_category_posts cp WHERE c.cat_id=cp.cat_id AND c.parent_id=0 AND cp.entry_id={entry_id}"}<a href="http://{parent_cat_url_title}">{parent_name}</a>{/exp:query}

This will only work if you assign an entry to both the child category and the parent category, but based on our PM’s, I already know you are 😊

Cheers,
Leon

Ah brilliant, thanks Leon.