How to order a database result-set?

Development Database

dmitrii_fediuk (Dmitrii Fediuk) April 4, 2016, 3:25pm 1

The SQL language has the ORDER BY keyphrase for ordering a result-set.

The Zend_Db_Select class has the order() method for it:

github.com

zendframework/zf1/blob/release-1.12.16/library/Zend/Db/Select.php#L577-L583


/**
 * Adds a row order to the query.
 *
 * @param mixed $spec The column(s) and direction to order by.
 * @return Zend_Db_Select This Zend_Db_Select object.
 */
public function order($spec)

An example

github.com

magento/magento2/blob/ab051bf/app/code/Magento/Catalog/Model/ResourceModel/Product/Collection.php#L1631-L1631


$this->getSelect()->order("is_saleable " . $dir);

How to order a database collection?