Driver_Database_Driver_MySQL::_compile_order_by

Compiles an array of ORDER BY statements into an SQL partial.

string Driver_Database_Driver_MySQL::_compile_order_by( object $columns )

参数列表

参数类型描述默认值

$columns object Database instance

参数	类型	描述	默认值
`$columns`	`object`	Database instance

返回值

string

File: ./drivers/database/mysql/mysql.class.php

protected function _compile_order_by(array $columns)
{
    $sort = array();
    foreach ($columns as $group)
    {
        list ($column, $direction) = $group;

        if (!empty($direction))
        {
            // Make the direction uppercase
            $direction = ' ' . strtoupper($direction);
        }

        $sort[] = $this->_quote_identifier($column) . $direction;
    }

    return 'ORDER BY ' . implode(', ', $sort);
}