->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