<?php
$db = JFactory::getDBO();
$db->setQuery('SELECT category_name FROM '.hikashop_table('category').'
WHERE category_id='.(int)$this->row->product_manufacturer_id);
$brandName = $db->loadResult();
?>
<?php
if (!empty($brandName)) {
echo JText::_('MANUFACTURER').': '. $brandName;
} else { echo " ";}
?>