orderBy DBA with more columns

Question

Patrick Ascher Jun '16

Created Jun '16	Last Reply Jun '16	Replies 1	Views 378	Votes 0

Patrick Ascher 8.1k

Hello to everyone, i wanna order a query like:

$query->orderBy('id ASC');

Thats working fine also a order like with more columns is working like that

$query->orderBy(array('id','email'));

but when i am trying to make something like that, i get an error that there is an error.

$query->orderBy(array('id ASC','email DESC'));

i was looking at the phalcon docs but cannot find anything about it. thanks for your help. pat

Wojciech Ślawski · Answer 1 · 2016-06-03T06:22:28-07:00

Wojciech Ślawski
145.0k

$query->orderBy('id ASC, email DESC');