->orderBy()
->orderBy() – Add an order by condition
Synopsis
void $DB_DataObject->orderBy (
string $order
)
Description
Adds a order by condition. Calling this without any arguments clears the current order condition.
Parameter
-
string $order- Order
Note
This function can not be called statically.
The quote_identifiers configuration option will not affect data sent to orderBy.
Example
Setting the order by
<?php
$person = new DataObjects_Person;
$person->orderBy('name');
$person->orderBy('age, eye');
$person->find();
// or with direction:
$person = new DataObjects_Person;
$person->orderBy('name ASC');
$person->orderBy('age DESC, eye');
$person->find();
?>
Resulting SQL
SELECT * FROM person ORDER BY name, age, eye