X-Cart forums

[sermad]

Hi guys.

How can I show the subcategory of a product on the products page?

[Dongan]

Hi,

I think this is what you are looking for...

http://forum.x-cart.com/viewtopic.php?t=5131

[sermad]

Thanks that is helping me understand things but no it didnt work for me.

Every product has a category - All I need is the variable for the all of its subcats and I'll be away! I can't seem to find it.

[sermad]

Firgured this out myself. Damn Im on a roll today!

Create a new page called 'sub_cat_fields_array.php' in modules/Sub_Cats

<?php 

if ( !defined('XCART_SESSION_START') ) { header("Location: ../../"); die("Access denied"); } 

if($products) {
    foreach($products as $product) { 
        $productid = $product['productid']; 
        $sub_cats[$productid] = func_query("SELECT $sql_tbl[products_categories].* FROM $sql_tbl[products_categories] WHERE ($sql_tbl[products_categories].productid = '$productid') AND $sql_tbl[products_categories].main='N'"); 
    } 
} 

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

?>

Then include the file in products.php

include $xcart_dir."/modules/Sub_Cats/sub_cat_fields_array.php";

Then in your products.tpl you can view the items subcats.

{assign var="subtcat" value=$sub_cats[$pid][0].categoryid}

This is for a product with one subcat. If your product has more then you need to loop through this.