[REVIEW] database->loadObjectList

Last reviewed: Not reviewed


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


array loadObjectList ( [ string $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).



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

might produce:

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

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

Last Updated ( Monday, 25 December 2006 )