How to display the name of the parent category?

Hi !

There are 2 categories with subcategories. When I do advanced search in subcategories, it shows the name of subcategory only in results listing.

The code that doing this is

<?php echo $row->category_name?>

in results.html.tpl.php.

But I want to display full path to found properties (ex. category - subcategory) in results page.

How to "echo" parent category`s name before the subcategory name?

Please help.

Hi,
The solution is change :
<?php echo $row->category_name?>
to
<?php
if($row->category_id > 0){
$db = Jfactory::getDBO();
$db->setQuery("Select parent_id from #__osrs_categories where id = '$row->category_id'");
$parent_id = $db->loadResult();
if($parent_id > 0){
$db->setQuery("Select category_name from #__osrs_categories where id = '$parent_id'");
echo $db->loadResult()." - ";
}
echo $row->category_name;
}

?>


Good luck
Dam

Thank you very much. It works.