Phoca Forum

Sorry i have see your post only now. Sorry again, i dont understand this tree.

I have this code:

$query = 'SELECT cc.title AS text, cc.id AS id, cc.parent_id as parentid, cc.alias as alias, cc.access as access, cc.accessuserid as accessuserid'
. ' FROM #__phocagallery_categories AS cc'
. ' WHERE cc.published = 1'
. ' AND cc.approved = 1'
. ' AND cc.parent_id = '.$category_id
. $hideCatSql
. $hideCatAccessSql
. ' ORDER BY cc.title,cc.ordering ASC';
$db->setQuery( $query );
$categoryData = $db->loadObjectList();

Thank you for your help!

pitschen wrote:
$query = 'SELECT cc.title AS text, cc.id AS id, cc.parent_id as parentid, cc.alias as alias, cc.access as access, cc.accessuserid as accessuserid'
. ' FROM #__phocagallery_categories AS cc'
. ' WHERE cc.published = 1'
. ' AND cc.approved = 1'
. ' AND cc.parent_id = '.$category_id
. $hideCatSql
. $hideCatAccessSql
. ' ORDER BY cc.title,cc.ordering ASC';
$db->setQuery( $query );
$categoryData = $db->loadObjectList();

I have solve my problem now with deleting the "cc.ordering" and writing "DESC" after cc.title. I hope its correct now and won´t take mistakes in future.
Thank you for your help!

Ok