how to display the category name on new_products.php?

[lucapaju]

Hello,

 

Please, someone knows how to show the category name on new_products.php?

 

I need to display new products, but along with the details I need to show the name of each product category.

 

I will show for each product:

 

Product Name

Image

Price, etc..

and Category Name.

 

I need of "product category name" to put on display.

 

 

Thank You!!!

 

 

[]'s Luiz

[web-project]

using the product id, you will be able to find the location of category name

[lucapaju]

Yes, my problem is that I am not managing to change original SQL query string.

 

... I can not get the manufaturer_id from product table.

 

 

[]'s

[lucapaju]

Ok.. I make thi"s.. in new_products.php:

 

$new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, p.manufacturers_id, pd.products_name, ....

 

after..

 

$fabricante1 = $new_products['manufacturers_id'];

$fabricante_query = tep_db_query("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$fabricante1 . "'");

$fabricante = tep_db_fetch_array($fabricante_query);

if ($fabricante['manufacturers_id'] != 0){

$fabricante2 = "<font color=#FFCC29>+</font> ". $fabricante['manufacturers_name'];

}else{

$fabricante2 = "";

}

 

 

 

... and use $fabricante2 to product informations if exist.

 

 

[]'s

[patrickluursema]

I always use the product ID, makes the finding simple.

Regards,

 

Patrick Luursema