Hello again , i have one more question.
which is the order of the categories shown?
I ordered by id categorie and by order in K2 Categories, but the module show in other order the categories. Where can i change it?

Example:
CAT1 - order 1 - id 10
CAT2 - order 2 - id 11
CAT3 - order 3 - id 12

The module show CAT2-CAT1-CAT3 ¿?

Thanks!

Hi,
Its posible to order the next SELECT?

$query = "
SELECT c.id, c.name as title, c.alias
FROM #__k2_categories c
WHERE
c.published = 1
AND c.parent = $catId
";

I don't know, but this select take the k2 categories from the table. But, in order?
The module display the categories in this order: (not is alphabetical order)

Cat5 (idcat=105) --- Cat1 (idcat=101) --- Cat9 (idcat=109)
Cat7 (idcat=107) --- Cat4 (idcat=104) --- Cat2 (idcat=102)
Cat3 (idcat=103) --- Cat6 (idcat=106) --- Cat10 (idcat=110)
Cat8 (idcat=108) --- Cat11 (idcat=111)

How i can change this order?. I want ordered by idcat or by another other than i can distribute (creation date, order in k2, icat, ...) but not in alphabetical order.

Its posible?

Very, very thanks.

I found the solution.

I change two SELECT and i include ORDER BY catid.


Thanks for me.