@cflsystems, your code worked like a charm! Here's the full code I used
In products.php below: $smarty->assign('cat_products', isset($products) ? $products : array());
HTML Code:
if (!empty($products)) {
foreach ($products as $k=>$v)
$products[$k]['manufacturer'] = func_query_first_cell("SELECT manufacturer FROM $sql_tbl[manufacturers] WHERE manufacturerid = $v[manufacturerid]");
}
Then add the following code into your product_details.tpl page where ever you want it
HTML Code:
<a href="manufacturers.php?manufacturerid={$product.manufacturerid}">{$product.manufacturer}</a>