API16

JDatabaseQuery/order

From Joomla! Documentation

< API16:JDatabaseQuery
Revision as of 15:39, 22 June 2012 by BastianW (talk | contribs) (→‎Examples: Added a small order example)

The "API16" namespace is an archived namespace. This page contains information for a Joomla! version which is no longer supported. It exists only as a historical reference, it will not be improved and its content may be incomplete and/or contain broken links.

[Edit Descripton]

Template:Description:JDatabaseQuery/order

Syntax[edit]

order($columns)
Parameter Name Default Value Description
$columns A string or array of ordering columns

Defined in[edit]

libraries/joomla/database/databasequery.php

Importing[edit]

jimport( 'joomla.database.databasequery' );

Source Body[edit]

public function order($columns)
{
        if (is_null($this->_order)) {
                $this->_order = new JDatabaseQueryElement('ORDER BY', $columns);
        } else {
                $this->_order->append($columns);
        }

        return $this;
}

[Edit See Also] Template:SeeAlso:JDatabaseQuery/order

Examples[edit]

<CodeExamplesForm />

$query->from('`#__categories` AS a');		
$query->where('a.extension = "com_weblinks" and a.published = "1"');		
$query->order('a.title ASC');