database->loadObjectList

Returns an array of database objects using the current SQL query.  Returns false if the query fails (prior to Joomla 1.1 returned null).

Syntax

array loadObjectList ( [ string $key ] )

$key

is the field name of a primary key. If $key is empty or null then loadObjectList will return a sequential list of the records returned by the database query. If $key is not empty or null then the array returned will be indexed by the value of the database key. This parameter is optional and if omitted will default to null (empty prior to Joomla 1.1).

Examples

Example:

function getCategories() {
  global $database;
 
  $sql = 'SELECT * FROM #__categories';
  $database->setQuery( $sql );
  $rows = $database->loadObjectList();
  foreach ( $rows as $row ) {
    echo "$row->title: $row->description\n";
  }
 
}
 
getCategories();

might produce:

Latest: The latest news from the Joomla Team
Joomla: A selection of links that are all related to the Joomla project.
Newsflash: 
Contacts: Contact Details for this web site
 

Please report any errors on this page to the Developer Documentation Forum.