Joomla 2.5 - retrieving categories list in order like in Category Manager

pletcherdkl

New Member
After googling and messing around for 2 days i've come to the dead end looking for a rescuer. :-)I want to get the categories just like in the same order they appear in Category Manager in Joomla backend.\[code\]$db =& JFactory::getDBO();$query = "select * from #__categories where extension='com_content' and title!='Uncategorised' order by parent_id,title,lft";$db->setQuery($query);$db->query();$hm = $db->getNumRows();$rows = $db->loadRowList();\[/code\]I insert the values in a DDL but there is some mess with their order. Any suggestion, please? Many thanks.
 
Back
Top