Displaying manufacturers name in product_info.php

[Davee]

Is it possible for me to add the manufacturers name in product_info.php page ?

 

If it is how? I have tried but yet to succeed? :(

 

Thanks in advance

 

Dave

[mrcold213]

I added something similar to my product info page.

 

-- basically you have to fisrt query the variable from table,

 

$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url,  p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

 

-- add manufature variable to that chunk of code

 

-- then check that it's not null

 

if (tep_not_null($manufacture['manufacture_namel'])) {

 

variable and syntax may vary depending on the variables you decide to use, but's that's the idea.

 

-- then echo it in any for you want.

 

<?php echo(.... ?>

 

 

Look into the product_info code and follow their model.