osCommerce / oscommerce2

      'cd.categories_name'

    ]);

    while ($Qcategories->fetch()) {

      if ($exclude != $Qcategories->valueInt('categories_id')) $category_tree_array[] = array('id' => $Qcategories->valueInt('categories_id'), 'text' => $spacing . $Qcategories->value('categories_name'));

      $category_tree_array = tep_get_category_tree($Qcategories->valueInt('categories_id'), $spacing . '   ', $exclude, $category_tree_array);

    }

    return $category_tree_array;

  }

    $Qcategories->bindInt(':language_id', $OSCOM_Language->getId());

    $Qcategories->execute();

    while ($Qcategories->fetch()) {

      $categories_array[] = array('id' => $Qcategories->valueInt('categories_id'),

                                  'text' => $indent . $Qcategories->value('categories_name'));

      if ($Qcategories->valueInt('categories_id') != $parent_id) {

        $categories_array = tep_get_categories($categories_array, $Qcategories->valueInt('categories_id'), $indent . '  ');

      }

    }

    return $categories_array;

  }