Yii 1.x: Why doesn't sorting work in CActiveRecord?

Question

Yii

I'm trying to get data from the model by sorting it by the sort_order field. The code is like this:

// Данные меню
$menu = Menu::model()->findAll('', array('order'=>'sort_order') );

However, the data is returned unsorted. When I iterate over the result:

foreach($menu as $item)
  echo $item['text'];

Then I see that the data is received as it is located in the database, without sorting by the sort_order field.
What's wrong?
I use the documentation here: www.yiiframework.com/doc/api/1.1/CActiveRecord#fin...

Answer 1

As far as I remember, it should be like this:

$menu = Menu::model()->findAll(array('order'=>'sort_order'));

Answer 2

Try it through CDBcriteria, it will be easier to understand the code later:

$criteria = new CDbCriteria;
$criteria->order = 'sort_order DESC';

$model = findAll($criteria);

Answer 3

three days ago the question arose how to bind to AR orderby. Driven into Google https://www.google.com/search?q=yii+findall+orderb...
on the first link the correct example. What's stopping you from doing so? it will take about 15 seconds.