osCommerce / oscommerce2

////

// Return all subcategory IDs

// TABLES: categories

  function tep_get_subcategories(&$subcategories_array, $parent_id = 0) {

    $subcategories_query = tep_db_query("select categories_id from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$parent_id . "'");

    while ($subcategories = tep_db_fetch_array($subcategories_query)) {

      $subcategories_array[sizeof($subcategories_array)] = $subcategories['categories_id'];

      if ($subcategories['categories_id'] != $parent_id) {

        tep_get_subcategories($subcategories_array, $subcategories['categories_id']);

      }

    }

  }

// Output a raw date string in the selected locale date format

// $raw_date needs to be in this format: YYYY-MM-DD HH:MM:SS

////

// Recursively go through the categories and retreive all parent categories IDs

// TABLES: categories

  function tep_get_parent_categories(&$categories, $categories_id) {

    $parent_categories_query = tep_db_query("select parent_id from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$categories_id . "'");

    while ($parent_categories = tep_db_fetch_array($parent_categories_query)) {

      if ($parent_categories['parent_id'] == 0) return true;

      $categories[sizeof($categories)] = $parent_categories['parent_id'];

      if ($parent_categories['parent_id'] != $categories_id) {

        tep_get_parent_categories($categories, $parent_categories['parent_id']);

      }

    }

  }

////

// Construct a category path to the product