Get parent id function

[delia]

I'm having to edit someone else's code. He's used $current_category_id to create if statements but what I also need is a function to use in case all subcategories fall under the same top category - ie the parent category.

So instead of this:

elseif($current_category_id == 104 || $current_category_id == 29 || $current_category_id == 41 || $current_category_id == 43 || $current_category_id == 47 || $current_category_id == 49)

it would something like this

elseif($parent_category_id == 1 )

I don't think any of the category functions can be used for this (but could be wrong) so writing a new function would be in order.

Wanted to make sure there wasn't something already usable in zen cart before I do something new.

[Ajeh]

How deep are your Categories?

Top Cat 1
-sub Cat1
-sub Cat2

Or do they go ...
Top Cat 1
-sub Cat1
--subsub CatA
--subcat CatB
-sub Cat2
--subsub CatA
--subsub CatB

[delia]

just one level of subs right now

[Ajeh]

You could build a function to get the parent_id by adding to a file in the:
/includes/functions/extra_functions/my_extra_functions.php

<?php

//// look up parent_id
  function zen_get_categories_parent_id($categories_id) {
    global $db;

    $lookup_query = "select parent_id from " . TABLE_CATEGORIES . " where categories_id='" . (int)$categories_id . "'";
    $lookup = $db->Execute($lookup_query);

    return $lookup->fields['parent_id'];
  }

Or if you already have a functions file in there for your customizations, just add that function to the bottom of it ...

Now, sent the categories_id you need to look up the parent_id for and it will return it ...

NOTE: if you go more than 1 level of Categories, you will need something more robust to dig up the cat tree ...

[delia]

great, that'll do for now.

Thank you Linda!

[Ajeh]

You are most welcome ...