orderBy for multiple columns

[beaucox]

Hi -

I'm having trouble with the orderBy method. When I want to order by more than one column I can't seem to pass the columns in an array as shown in your GitHub docs. I have a feeling I'm missing the boat here... Can anyone help me?

This doesn't work:

$query = QB::table('movies')
  ->select(array('fs_name','name','release_date', 'rating','video_format','imdb_stars'));
$query->orderBy(array( 'release_date', 'DESC', 'sort_name', 'ASC'));
$queryObj = $query->getQuery();
echo $queryObj->getRawSql();
$result = $query->get();

Errors:

Warning: explode() expects parameter 2 to be string, array given in .../vendor/usmanhalalit/pixie/src/Pixie/QueryBuilder/Adapters/BaseAdapter.php on line 360
Warning: Invalid argument supplied for foreach() in .../vendor/usmanhalalit/pixie/src/Pixie/QueryBuilder/Adapters/BaseAdapter.php on line 362
Warning: implode(): Invalid arguments passed in .../vendor/usmanhalalit/pixie/src/Pixie/QueryBuilder/Adapters/BaseAdapter.php on line 368
...

The raw SQL is:

SELECT `fs_name`, `name`, `release_date`, `rating`, `video_format`, `imdb_stars` FROM `movies` ORDER BY ASC

This works:

$query = QB::table('movies')
  ->select(array('fs_name','name','release_date', 'rating','video_format','imdb_stars'));
$query->orderBy('release_date', 'DESC');
$query->orderBy('sort_name', 'ASC');
$queryObj = $query->getQuery();
echo $queryObj->getRawSql();
$result = $query->get();

The raw SQL is:

SELECT `fs_name`, `name`, `release_date`, `rating`, `video_format`, `imdb_stars` FROM `movies` ORDER BY `release_date` DESC,`sort_name` ASC

[usmanhalalit]

Hi,

If you want to use DESC then you've to put multiple orderBy like this

$query->orderBy('release_date', 'DESC')->orderBy('sort_name');