Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

manufacturers grab and echo


SerbanG

Recommended Posts

this might help

 

$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);



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

 

this should give you the manufacturers name for a given product (from calling its product_id)

 

let me know if this works for you.

Reddy to Rumble

 

Thank you osCommerce and all who Contribute to her!

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...