Antwort #2 am: 07. September 2010, 14:27:42
Wenn's ein bisschen mehr sein darf.
// BOF - Tomcraft - 2009-07-02 - Get manufacturer name etc. for the product page
$manufacturer_query = xtc_db_query("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");
if (xtc_db_num_rows($manufacturer_query)) {
$manufacturer = xtc_db_fetch_array($manufacturer_query);
$manufacturers_image='';
if (xtc_not_null($manufacturer['manufacturers_image'])) $manufacturers_image=DIR_WS_IMAGES . $manufacturer['manufacturers_image'];
$info_smarty->assign('MANUFACTURER_IMAGE',$manufacturers_image) ;
$info_smarty->assign('HERSTELLER',$manufacturer['manufacturers_name']);
$info_smarty->assign('MANUFACTURER_LINK','<a href="' . xtc_href_link(FILENAME_DEFAULT, xtc_manufacturer_link($manufacturer['manufacturers_id'],$manufacturer['manufacturers_name'])) . '">Mehr Produkte von ' . $manufacturer['manufacturers_name'] . '</a>');
}
// EOF - Tomcraft - 2009-07-02 - Get manufacturer name etc. for the product page
Grüße
Torsten