Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

how to display the category name on new_products.php?


Recommended Posts



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


Price, etc..

and Category Name.


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



Thank You!!!



[]'s Luiz

Link to comment
Share on other sites

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

Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!

8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.

Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.

Any issues with oscommerce, I am here to help you.

Link to comment
Share on other sites

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, ....




$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'];


$fabricante2 = "";





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




Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...