Categories block problem

[Azurious]

Categories not showing in correct order as they are set by me in block wat can be the problem :unknown:

[joeroberts]

Open theme main.php
find

PHP Code:

            $rq = "SELECT id, name FROM ".$db_prefix."_categories ORDER BY name"; 


replace with

PHP Code:

            $rq = "SELECT id, name FROM ".$db_prefix."_categories ORDER BY sort_index, id ASC"; 


[Azurious]

thanks solved