In case you weren’t aware, you can reorder the results you already have from a previous Yii call. For example…
$users = User::model()->findByPk(2);
$posts = $user->posts(array('order'=>' created Desc '));
There were just ordered our users posts by created date descending.
We can also do filtering…
$users = User::model()->findByPk(2);
$posts = $user->posts(array('condition'=>' status=1 '));
So now we only have active posts. We could also combine a condition and a status.
You can find out more here: http://www.yiiframework.com/doc/guide/1.1/en/database.arr#dynamic-relational-query-options
[carousel keywords=”yii” tag=”fetchit-21″]