Выводим информацию о производителе на карточке товара (VAM shop)

$info->assign('PRODUCTS_STATUS', $product->data['products_status']);

$info->assign('PRODUCTS_STATUS', $product->data['products_status']);

$manufacturer_query = vamDBquery("select m.manufacturers_id, m.manufacturers_name, 
m.manufacturers_image, mi.manufacturers_url from " . TABLE_MANUFACTURERS . " 
m left join " . TABLE_MANUFACTURERS_INFO . " mi on (m.manufacturers_id = 
mi.manufacturers_id and mi.languages_id = '" . (int)$_SESSION['languages_id'] 
. "'), " . TABLE_PRODUCTS . " p  where p.products_id = '" 
. $product->data['products_id'] . "' and p.manufacturers_id = m.manufacturers_id");
      $manufacturer = vam_db_fetch_array($manufacturer_query,true);
      $info->assign('MANUFACTURER',$manufacturer['manufacturers_name']);
      $info->assign('MANUFACTURER_IMG',$manufacturer['manufacturers_image']);
      $info->assign('MANUFACTURER_LINK',$manufacturer['manufacturers_url']);

$manufacturer_query = vamDBquery("select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, mi.manufacturers_url from " . TABLE_MANUFACTURERS . " m left join " . TABLE_MANUFACTURERS_INFO . " mi on (m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '" . (int)$_SESSION['languages_id'] . "'), " . TABLE_PRODUCTS . " p where p.products_id = '" . $product->data['products_id'] . "' and p.manufacturers_id = m.manufacturers_id"); $manufacturer = vam_db_fetch_array($manufacturer_query,true); $info->assign('MANUFACTURER',$manufacturer['manufacturers_name']); $info->assign('MANUFACTURER_IMG',$manufacturer['manufacturers_image']); $info->assign('MANUFACTURER_LINK',$manufacturer['manufacturers_url']);

{if $MANUFACTURER}
<p>{$MANUFACTURER}</p>
{/if}
{if $MANUFACTURER_LINK}
<p><img src="images/{$MANUFACTURER_IMG}" /></p>
{/if}
{if $MANUFACTURER_LINK}
<p><a href="{$MANUFACTURER_LINK}">{$MANUFACTURER_LINK}</a></p>
{/if}

{if $MANUFACTURER} <p>{$MANUFACTURER}</p> {/if} {if $MANUFACTURER_LINK} <p><img src="images/{$MANUFACTURER_IMG}" /></p> {/if} {if $MANUFACTURER_LINK} <p><a href="{$MANUFACTURER_LINK}">{$MANUFACTURER_LINK}</a></p> {/if}