[BCSE]

Someone came to me unable to get this code to work on their site and I wasn't able to fix it either so I created another way to do this.

To show the manufacturer on a per product basis on products.php you can also do this instead:

In products.php before:

$smarty->assign("products",$products);

Insert:

if($products)
{
	foreach($products as $key=> $product)
		$products[$key]["manufacturer"]= func_query_first_cell("select manufacturer from $sql_tbl[manufacturers] where manufacturerid=".$product["manufacturerid"]);
}

In skin1/customer/main/products_t.tpl or skin1/customer/main/products.tpl insert the following where you want the manufacturer to show up

{$products[product].manufacturer}

Hope that helps those who are stuck! A bit less code and less files to edit.

Carrie