Documentation Home
MySQL PHP API
Download this Manual
PDF (US Ltr) - 2.4Mb
PDF (A4) - 2.4Mb
HTML Download (TGZ) - 250.9Kb
HTML Download (Zip) - 258.4Kb


MySQL PHP API  /  ...  /  CollectionModify::sort

5.10.11 CollectionModify::sort

Copyright 1997-2019 the PHP Documentation Group.

  • CollectionModify::sort

    Set the sorting criteria

Description

public mysql_xdevapi\CollectionModify mysql_xdevapi\CollectionModify::sort(string sort_expr);

Sort the result set by the field selected in the sort_expr argument. The allowed orders are ASC (Ascending) or DESC (Descending). This operation is equivalent to the 'ORDER BY' SQL operation and it follows the same set of rules.

Warning

This function is currently not documented; only its argument list is available.

Parameters

sort_expr

One or more sorting expression can be provided, the evaluation of these will be from the leftmost to the rightmost, each expression must be separated by a comma.

Return Values

CollectionModify object that can be used for further processing.

Examples

Example 5.50 mysql_xdevapi\CollectionModify::sort example

<?php

$res = $coll->modify('true')->sort('name desc', 'age asc')->limit(4)->set('Married', 'NO')->execute();

?>