Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

how to display the category name on new_products.php?


lucapaju

Recommended Posts

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

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

 

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

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...