Sort by for Category?

[Chill_user]

Hello guys,

I have few questions about query.

I like to sort data by 'position' (show categories by position)

$query = 'SELECT * 
        FROM `'._DB_PREFIX_.'category` 
        WHERE `id_parent` = '.$id_category.' AND `active` = '.$active.'
        ORDER BY `position` ASC';    
$results = Db::getInstance()->executeS($query);

Query is working, but not sorting by 'position' ; it's sorting by 'id'

Table: prefix_category