model query

Question

model query

ctuanminh Mar '14

Created Mar '14	Last Reply Mar '14	Replies 2	Views 1555	Votes 0

ctuanminh 20.3k

Mar '14

Dear, I get an error when using query model Deprecated: Function Phalcon\Mvc\Model\Criteria::order() is deprecated in F:\xampp\htdocs\fmv2\app\controllers\DiscussionsController.php on line 83**

$this->view->categoriesLevel1 = Categories::query()
                ->where("type_cat = 1")
                ->andWhere("level = 1")
                ->bind(array())
                ->order("number_posts DESC, name")
                ->execute();

How to fix??

Dylan Anderson
125.8k

Accepted
answer

Mar '14

Simplest would be to just use find()

$this->view->categoriesLevel1 = Categories::find(['type_cat = 1 AND level = 1','order'=>'number_posts DESC, name']);

Phalcon · Answer 1 · 2014-03-28T08:35:57-07:00

Use:

$this->view->categoriesLevel1 = Categories::query()
                ->where("type_cat = 1")
                ->andWhere("level = 1")
                ->bind(array())
                ->orderBy("number_posts DESC, name")
                ->execute();