X-Cart forums

[Omron Khan]

I am kinda in a serious predicament here . Check this link
http://www.taqshop.com/xcart/home.php?cat=333
On the left sidebar you can see the sub catgeories of the parent category Technology.

I want to display the same subcategories in the subcategories individual pages also. like here http://www.taqshop.com/xcart/home.php?cat=388

Current code of mine which i use to display the subcategory is

<ul>
{foreach from=$categories item=subcategory}

   <li>  <a href="home.php?cat={$subcategory.categoryid}">{$subcategory.category|escape}</a></li>


{/foreach}
</ul>

but with this i cant display the subcategories in the subcatgeory page. It will only display the subcategories of the current subcategory.

Any help will be appreciated

[Omron Khan]

Anyway solved this issue. i made a new tpl file and called it in the sidebar. Here's the code in the tpl file:

{php}
$t = $this->get_template_vars('cat'); 

$result=mysql_query("select * from xcart_categories where categoryid=$t");
while($row=mysql_fetch_array($result))
{
$cid=$row['categoryid'];
$pid=$row['parentid'];
$cat=$row['category'];
}
{/php}
<ul>
{php}

if($pid==0){
$res=mysql_query("select * from xcart_categories where parentid=$t");
while($row1=mysql_fetch_array($res))
{
$cat12=$row1['category'];
$cid12=$row1['categoryid'];

{/php}<li><a href="home.php?cat={php}echo $cid12; {/php}">{php}
echo $cat12;{/php}</a></li>{php}
}
}else {
$res=mysql_query("select * from xcart_categories where parentid=$pid");
while($row1=mysql_fetch_array($res))
{
$cat12=$row1['category'];
$cid12=$row1['categoryid'];
{/php}<li><a href="home.php?cat={php}echo $cid12; {/php}">{php}
echo $cat12;{/php}</a></li>{php}
}

}
{/php}
</ul>

if you wanna see a live demo of it check here
http://www.taqshop.com/xcart/home.php?cat=361

[nickff]

Brilliant Solution, Omron.

I implemented like so, using a dropdown menu at the top of my category pages:

In subcategories.tpl:

{include file="customer/main/subcategories_dropdown.tpl"}

In subcategories_dropdown.tpl:

{php}
        $t = $this->get_template_vars('cat'); 
        
        $result=mysql_query("select * from xcart_categories where categoryid=$t");
        while($row=mysql_fetch_array($result))
        {
            $cid=$row['categoryid'];
            $pid=$row['parentid'];
            $cat=$row['category'];
        }
     {/php}
     <select name="mySelect" class="gender-select" onchange="if(this.options[this.selectedIndex].value != '')window.top.location.href=this.options[this.selectedIndex].value">
         <option value="Select A Gender">mens/womens/youth</option>
         {php}
            
            if($pid==0){
            $res=mysql_query("select * from xcart_categories where parentid=$t");
            while($row1=mysql_fetch_array($res))
            {
            $cat12=$row1['category'];
            $cid12=$row1['categoryid'];
            
         {/php}
         <option value="home.php?cat={php}echo $cid12; {/php}">{php}echo $cat12;{/php}</option>
         {php}
            }
            }else {
            $res=mysql_query("select * from xcart_categories where parentid=$pid");
            while($row1=mysql_fetch_array($res))
            {
            $cat12=$row1['category'];
            $cid12=$row1['categoryid'];
         {/php}
         <option value="home.php?cat={php}echo $cid12; {/php}">{php}echo $cat12;{/php}</option>
         {php}
            }
            
            }
        {/php}
    </select>

Works perfectly!