database->setQuery

Sets the SQL query string for later execution.  This function also replaces all occurrences within the query string of a given string identifier with the current database table prefix code.  Note that this function does not cause the SQL query to be executed.

Syntax (prior to Joomla 1.0)

void setQuery ( string $query [, string $prefix] )

$query

is the SQL query string.

$prefix

is the string identifier to be replaced by the current database table prefix code.  This parameter is optional and if omitted will default to '#__'.

Syntax (from Joomla 1.0 onwards)

void setQuery ( sting $query [, integer $offset [, integer $limit [, string $prefix ]]] )

$query

is the SQL query string

$offset

is the table row offset for use with page navigation code.  This parameter is optional and if omitted will default to null.

$limit

is the maximum number of rows to be returned by the SQL query.  This parameter is optional and if omitted will default to null.

$prefix

is the string identifier to be replaced by the current database table prefix code.  This parameter is optional and if omitted will default to '#__'.

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.