This is what I’m going to have to do, the problem is if the client adds a catagory the we’ll need to amend this code as the IDs are hard coded so it aint great:
{exp:query sql = ” SELECT cat_id AS parent_category_id,
cat_name AS parent_category_name,
cat_url_title AS parent_category_url_title,
cat_description AS parent_category_description,
cat_image AS parent_cat_image,
cat_order AS parent_cat_order
FROM exp_categories WHERE cat_id = ‘11’ ORDER BY cat_order”}
<h1>parent ID: {parent_category_id}</h1>
<p>parent Name: {parent_category_name}</p>
<p>parent Title: {parent_category_url_title}</p>
<p>parent Image: {parent_cat_image}</p>
<p>parent Description: {parent_category_description}</p>
{/exp:query}
{exp:query sql = ” SELECT cat_id AS child_category_id,
cat_name AS child_category_name,
cat_url_title AS child_category_url_title,
cat_description AS child_category_description,
cat_image AS child_cat_image,
cat_order AS child_cat_order
FROM exp_categories WHERE parent_id = ‘11’ ORDER BY cat_order”}
<h2>child ID: {child_category_id}</h2>
<p>child Name: {child_category_name} </p>
<p>child Title: {child_category_url_title} </p>
<p>child Image: {child_cat_image} </p>
<p>child Description: {child_category_description}</p>
{/exp:query}
If anyone has a better idea how to achieve this please let us know, the worknig example can be seen here http://probel.previewurl.net/ click on the left nav to get a pop up whic will display child catagories.
