It is always a good idea to display manufacturer's names with product names in the order email if a certain product could be associated with several different manufacturers. This recipe shows you how to add the manufacturer's name for each product using a function, just as promised in the previous recipe.
Your product listing in the Order Confirmation email will look like the following Screenshot:
function tep_get_manufacturers_name($products_id) {
$manufacturers_query = tep_db_query("select m.manufacturers_name from " .
TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS .
" p where p.manufacturers_id = m.manufacturers_id...