How to display subcategories names from categorie PHP SOLVED

[MFLM]

Hi all

 

I really like to know, How I can display the subcategories names from a category in one array.

 

Example:

 

CATEGORIE 

• SUBCATEGORIE1
• SUBCATEGORIE2

 

I have a CATEGORIE, and I need to show SUBCATEGORIE1 and SUBCATEGORIE2 like 

Names:"SUBCATEGORIE1 ,SUBCATEGORIE2"

 

That in PHP code.

 

I think is of one class from Category.php

 

Thanks

 

 

I solved this with a query

 

SELECT cl.name FROM `ps_category`c LEFT JOIN `ps_category_lang`cl ON (c.`id_category` = cl.`id_category`AND `id_lang` = 1) WHERE c.`id_parent` =3  AND cl.`id_shop` =19

Edited May 5, 2017 by MFLM (see edit history)