Help with categories parent_id in product listing

smic717394 · **Joined:** Sun Apr 17, 2005 12:00 am **Posts:** 104

I need a little help please... basically what I want to to is display certain information on product listing page based on the categories parent_id.

If I try to display the parent_id from the query bellow I keep getting 0

Code:

<?
    $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = cd.categories_id and cd.language_id='" . $languages_id ."' order by sort_order, cd.categories_name");
      $product_info1 = tep_db_fetch_array($categories_query);
      
     echo $product_info1['parent_id'];
 ?>

If from the same query I try

Code:

echo $product_info1['categories_name];

, I get the correct category name where the product is located, as well as if I try

Code:

echo $product_info1['categories_id];

I get the correct number of the category where the product is located in.

I just cant get the parent_id. Can anybody please help me find what I'm doing wrong or with the correct query.

greatpcs · **Posted:** Tue Mar 09, 2010 11:06 pm

0 would be a top category.. are you sure you are echoing on a sub cat

smic717394 · **Joined:** Sun Apr 17, 2005 12:00 am **Posts:** 104

Yes, I know the for sure the parent id should be 8. I dont know. I also tried the query as bellow, with the exact same resoult.

Code:

     $categories_query = tep_db_query("select c.categories_id, p.products_id, p.categories_id, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p where c.categories_id = p.categories_id");
      $product_info1 = tep_db_fetch_array($categories_query);
      
     echo $product_info1['parent_id'];

smic717394 · **Joined:** Sun Apr 17, 2005 12:00 am **Posts:** 104

OK, I'm getting close, with the query bellow I get the parent ID of the current,is there any way of getting the main parent id. For example my main category has the parent_id 8 some categories have subcategories, and then the subcategory parent_id will not be 8 any more will be whatever id the category in which is located has.

What I'm trying to do is display another tab but only when the main parent_id is 8.

Code:

 
 $categories_query = tep_db_query("select p.products_id, p.products_model, c.categories_id, c.parent_id, pc.products_id, pc.categories_id, c.categories_image
 from " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc where p.products_id = '" . (int)$_GET['products_id'] . "' and pc.products_id = p.products_id and pc.categories_id = c.categories_id");
  $categories = tep_db_fetch_array($categories_query);

echo $categories['parent_id'];

CRE Loaded Community

Help with categories parent_id in product listing

Who is online

Main Menu

Login

Top Listing

Members Online

Follow Us on Twitter

CRE Loaded Community Chat hosted by CRE Loaded.