Categories translations - alphabetical order

I am not sure why it is not working with Falang, because i am not exactly understand how it works. But I asume that ORDER BY in SQL query always applied to the same column.

I am really not sure how to make sure it orders on both languages. I'll ask Falang developers and let you know.

Thanks for your reply, Sergey.

Falang is based on Joomfish, and you can find the dev doc here :

http://www.joomfish.net/en/the-club/index.php?option=com_content& ;task=category&sectionid=2&id=5&Itemid=15

Falang is very easy to use (nothing to do !, only include the primary key) in a component / module.

If you use a query like :

$query = "SELECT id, title FROM #__js_res_categories ORDER BY title";

All 'title' will be translated but the order is the db non translated title

So you have to re-order the query result according to the translated title.

Regards.

Let's see. There is a posibility that it is not possible with how I get categories. I'll find out and tell you. Perhaps there is no other order but only by ordering. I'll wait for answer from falang and then form my answer.

Sergey Let's see. There is a posibility that it is not possible with how I get categories. I'll find out and tell you. Perhaps there is no other order but only by ordering. I'll wait for answer from falang and then form my answer.

Any news ?

Unfortunately sort by title is impossible. We use nested set technique, and it always order by lft or so to say left. And that create continues tree structure.

There is no way to order by title.

But i added c.title into select, let's see how it will work after update.