OK I got this to work:
In product.php I have:
PHP Code:
# Start show categories for each product (ADD-ON)
$product_cat = func_query("SELECT category, categoryid FROM $sql_tbl[categories] WHERE categoryid IN (SELECT categoryid FROM $sql_tbl[products_categories] WHERE productid ='$productid')");
if (!empty($product_cat)) {
foreach ($product_cat as $c => $d) {
$explode_cats[] = $d;
}
$smarty->assign("explode_cats", $explode_cats);
}
# end add to show categories for each product (ADD-ON)
Then in product.tpl I have the following:
---------------------------------------
<div>
{foreach from=$explode_cats item=c}
{assign var=Pcatid value=$c.categoryid}
{assign var=Pcatname value=$c.category}
<a href="search.php?mode=search&including=any&categor yid={$Pcatid}" title="{$Pcatname}">{$Pcatname}</a> |
{/foreach}
</div>
I HOPE THIS HELPS SOMEONE...
THANKS FOR ALL THE HELP
