В шаблоне админки “Редактировать товар” вытащить название производителя - JoomShopping

<?php  //Manufacturer name//
	$db = JFactory::getDBO();
	$sql = "SELECT * FROM #__jshopping_manufacturers";
	$db->setQuery($sql);
	$factories = $db->loadObjectList();
	foreach($factories as $factory){
		$name_brend = JSFactory::getLang()->get("name");
		$brends[$factory->manufacturer_id] = $factory->$name_brend;
	}
	
	echo $brends[$row->product_manufacturer_id];
?>

$( "#mysel option:selected" ).text();

        $lists['manufacturers'] = JHTML::_('select.genericlist', $manufs,'product_manufacturer_id','class = "inputbox" size = "1"','manufacturer_id','name',$product->product_manufacturer_id);
        $view->assign('lists', $lists);

<script>document.write($("#product_manufacturer_id option:selected").text());</script>

<?php	//Manufacturer name//
$db = JFactory::getDBO();
$query = "SELECT * FROM #__jshopping_manufacturers WHERE manufacturer_id={$row->product_manufacturer_id}";
$db->setQuery($query);
$factories = $db->loadObjectList();
foreach($factories as $factory){
    $brend_name = JSFactory::getLang()->get("name");
    echo $factory->$brend_name;
}
?>