database->loadRow

Returns the first row of the current query as an array.  If the query fails then returns null.

Syntax

array loadRow ( )

Examples

Example: This function prints an array containing all the fields from a given Joomla category record.

function getCategory( $title ) {
  global $database;
 
  $title = $database->Quote( $title );
  $sql = "SELECT * FROM #__categories WHERE title=$title";
  $database->setQuery( $sql );
  $category = $database->loadRow();
  print_r( $category );
 
}
 
getCategory( 'Latest' );

might produce:

Array
(
    [0] => 1
    [1] => 0
    [2] => Latest
    [3] => Latest News
    [4] => taking_notes.jpg
    [5] => 1
    [6] => left
    [7] => The latest news from the Joomla Team
    [8] => 1
    [9] => 0
    [10] => 2000-00-00 00:00:00
    [11] => 
    [12] => 0
    [13] => 0
    [14] => 1
    [15] => 
)
 

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