TableSelect::orderby

(No version information available, might only be in Git)

TableSelect::orderby — Set select sort criteria

public mysql_xdevapi\TableSelect mysql_xdevapi\TableSelect::orderby ( mixed $sort_expr [, mixed $... ] )

Sets the order by criteria.

sort_expr: The expressions that define the order by criteria. Can be an array with one or more expressions, or a string.
...: Additional sort_expr parameters.

A TableSelect object.

Example #1 mysql_xdevapi\TableSelect::orderby() example


<?php

$res = $table->select(['name','age'])->where('name in (\'Cassidy\',\'Polly\')')->orderBy(['age desc','name asc'])->execute();

?>