X-Cart forums

[mrerotic]

ok the following is what I added to product.php

PHP Code:

// TEST ADDITION //
$product_cat = func_query("SELECT category 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['category'];
}
 
$smarty->assign("explode_cats", $explode_cats);
}
// END TEST ADDITION // 


And in product.tpl I added:
------------------------------
<div>
{foreach from=$explode_cats item=c}
<a href="search.php?mode=search&including=any&categor yid=1" title="{$c}">{$c}</a> |
{/foreach}
</div>

How can I pass the category id's to product.tpl in above so each href is correct for each categoryid? I have the categories passing correctly, I just can't figure out how to get the id's.

Thanks

[mrerotic]

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

[flamers]

Hi mrerotic, I also want to explode extra field items (a performer list, exactly the same as your initial query on this thread) but I am having a little difficulty following the code changes needed. Could you possibly post the coding changes that you carried out to make a hyperlink for each performer name?

Thanks in advance.