Quote Originally Posted by hem View Post
Comment out or delete the following:

PHP Code:
        $products_tab_query="SELECT p.`products_id`, pd.`products_name`, pd.`language_id` FROM ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_DESCRIPTION." pd WHERE p.`master_categories_id`='".(int)$categories_tab->fields['categories_id']."' AND p.`products_id`=pd.`products_id` AND pd.`language_id`='".(int)$_SESSION['languages_id']."' ORDER BY p.`products_sort_order`;";
        
$products_tab=$db->Execute($products_tab_query);
        if(
$products_tab->RecordCount()>0)
        {
            echo 
'<ul>';
            while (!
$products_tab->EOF
            {    
                
$cPath_new=zen_get_path($categories->fields['categories_id']);
                
$cPath_new=str_replace('=0_''='$cPath_new);
                echo 
'<li>'.'<a href="'.zen_href_link(zen_get_info_page($products_tab->fields['products_id']),$cPath_new'&products_id=' $products_tab->fields['products_id']) . '">'.$products_tab->fields['products_name'].'</a></li><br />';
                
$products_tab->MoveNext();
            }
            echo 
'</ul>';
        } 
This worked a charm, thanks hem.
Now I just have this alignment weirdness to sort out.