Get default category name

[Nuvish]

Given any id_category, how can i know the name of its default category(where id_parent = 1)?


Is there any function in which i can pass any category id and it returns name of corresponding default category?

[Nuvish]

This can be a solution if ever some1 needs it.

public static function getFirstParentCategories($idLang, $id_cat)
       { 
               $categories = null;

               while (true)
               {
                   $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS('
                       SELECT c.*, cl.*
                       FROM `'._DB_PREFIX_.'category` c
                       LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = '.(int)($idLang).')
                       WHERE c.`id_category` = '.(int)$id_cat.' AND c.`id_parent` != 0
                   ');

                   $categories[] = $result[0];
                   if(!$result OR $result[0]['id_parent'] == 1)
                       return $result;
                   $id_cat = $result[0]['id_parent'];
               }
       }