[HWT]

This also works like a charm for the search (thanks everyone who's posted) - this is an extension of Carrie's solution

in include/search.php

just before:

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

include:

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

To get the manufacturer's name to hyperlink, simply use:

 <a href="manufacturers.php/?manufacturerid={$products[product].manufacturerid}">{$products[product].manufacturer}</a> 

instead of:

{$products[product].manufacturer} 

where you would like it to show up in skin1/customer/main/products_t.tpl or skin1/customer/main/products.tpl