TerryK Posted December 18, 2003 Share Posted December 18, 2003 I've figured out how to get the manufacturer name to display within my product listing. Now I'm trying to figure out how to LINK it to their manufacturer_id to display their other products, but I've hit a roadblock. I know this has to be easy. Could someone please help this PHP-challenged being figure out how to turn it into a link? Here's the code I'm using: $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); Then within my product listing, I've got: <?php echo $manufacturer['manufacturers_name']; ?> What am I missing? Please help... Many thanks, Terry Terry Kluytmans Contribs Installed: Purchase Without Account (PWA); Big Images, Product Availability, Description in Product Listing, Graphical Infobox, Header Tags Controller, Login Box, Option Type Feature, plus many layout changes & other mods of my own, like: Add order total to checkout_shipment Add order total to checkout_payment Add radio buttons at checkout_shipping (for backorder options, etc.) Duplicate Table Rate Shipping Module Better Product Review Flow * If at first you don't succeed, find out if there's a prize for the loser. * Link to comment Share on other sites More sharing options...
geenygreat Posted December 18, 2003 Share Posted December 18, 2003 <?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT , 'manufacturers_id=' . $manufacturer['manufacturers_id']) . '">'. $manufacturer['manufacturers_name'] . '</a>' ; ?> Hope it works! Link to comment Share on other sites More sharing options...
TerryK Posted December 18, 2003 Author Share Posted December 18, 2003 Thank you, thank you, thank you!! It works perfectly! Terry Terry Kluytmans Contribs Installed: Purchase Without Account (PWA); Big Images, Product Availability, Description in Product Listing, Graphical Infobox, Header Tags Controller, Login Box, Option Type Feature, plus many layout changes & other mods of my own, like: Add order total to checkout_shipment Add order total to checkout_payment Add radio buttons at checkout_shipping (for backorder options, etc.) Duplicate Table Rate Shipping Module Better Product Review Flow * If at first you don't succeed, find out if there's a prize for the loser. * Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.