Manufacturer in product info?

[elchavobeer]

This has got to be quite easy, but I can't seem to find what I need. I'm using the manufacturer field as an Author field (for books) and it shows up fine when you click on the category. But when I click on an individual item, the manu. field is not there and I can't seem to find what to change to make this simple adjustment. I played around with product_info.php but can't seem to get the manu. field to display.

Any help is appreciated. EL CHAVO!

[Guest]

in products_info.php look for:

	if (tep_not_null($product_info['products_model'])) {
  $products_name = $product_info['products_name'] . '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>';
} else {
  $products_name = $product_info['products_name'];
}

 

add below:

$manufacturer_query = tep_db_query("select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image from " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS . " p  where p.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and p.manufacturers_id = m.manufacturers_id");
$manufacturer = tep_db_fetch_array($manufacturer_query);

 

then wherever you want the manufacturer name:

<?php echo $manufacturer['manufacturers_name']; ?>

[elchavobeer]

Thanks, that works out perfectly! Shoulda asked a few hours ago...