Get the category name?

[nineteen83]

Hi guys,

 

Bit of a newbie, but I've searched high and low and cannot get the category name of the product to show up on product.tpl!

 

I've tried 

 

<h1>{$category->name}</h1>

 

No to avail. Any tips? Thanks!

K

[nineteen83]

So, this sort of works...

 

{$return_category_name}

 

but only on some pages? Confusing!

[nineteen83]

So since nobody knows, or is not sharing, I managed to hack product.php and added

 

		$result = Db::getInstance()->ExecuteS('

	SELECT `id_category` FROM `'._DB_PREFIX_.'category_product` WHERE `id_product` = '.intval($_GET['id_product']).'');


	$smarty->assign('current_category_id',$result);

	$result_catname = Db::getInstance()->ExecuteS('

	SELECT `name` FROM `'._DB_PREFIX_.'category_lang` WHERE `id_category` = '.intval($result[0]['id_category']).'');


	$smarty->assign('current_category',$result_catname);

 

 

And on product.tpl, {$current_category[0].name} will show the category name of the current product.

 

Hopefully this helps someone out there...

 

Ciao

 

 

[shagshag]

Hi,
I use this in product.tpl on RC3 :

{if $category}
   {$category->name}
{elseif $product->id_category_default != 1}
   {php}
       global $product, $cookie;
       $this->assign('default_category', new Category($product->id_category_default, $cookie->id_lang));
   {/php}
   {$default_category->name}
{else}
   {$shop_name}
{/if}

it's bad to use php in template file but I think it's better than hack product.php

Regards

[cerberus22]

Hi All,
Does anybody know how to turn shagshags reply into a link ?

All the best,
Cerberus22