Show categories as attributes in product view?

[be]

Hi,
how can I show the multiple categories from one product in the productview?
Actally I use

Code Select Expand

$this->category->category_name;,
but with this I got only displayed the category in which I´m actually be and not all the categories where the product is set in the backend under
"Product Information".

Propably it could be possible to solve this with a direct db-query like this:

Code Select Expand


$dbcat = JFactory::getDBO();
$dbcat->setQuery("SELECT custom_value FROM #__virtuemart_product_customfields WHERE virtuemart_product_id=".$product->virtuemart_product_id." and virtuemart_custom_id=17 ;"); 
$dbcat->query();
$resultcat = $db2->loadResult();

But my programingskills are to small to get the db-query for the multiple categories work, also because the Information is stored in several mysql-tables.

BR