API16

JDatabaseQuery/order: Difference between revisions

From Joomla! Documentation

m clean up
m preparing for archive only
 
Line 38: Line 38:


===Examples===
===Examples===
<CodeExamplesForm />
=== Code Examples ===
<source lang="php">
<source lang="php">
$query->from('`#__categories` AS a');
$query->from('`#__categories` AS a');
Line 49: Line 49:
  category=order
  category=order
  category=JDatabaseQuery
  category=JDatabaseQuery
  category=CodeExample
  namespace=CodeExample
  category=MethodExample
  category=MethodExample
  include=*
  include=*

Latest revision as of 01:30, 25 March 2017

<! removed transcluded page call, red link never existed >

Syntax

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

Defined in

libraries/joomla/database/databasequery.php

Importing

jimport( 'joomla.database.databasequery' );

Source Body

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

        return $this;
}


<! removed transcluded page call, red link never existed >

Examples

Code Examples

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