JDatabase/setQuery

The "API15" namespace is an archived namespace. This page contains information for a Joomla! version which is no longer supported. It exists only as a historical reference, it will not be improved and its content may be incomplete and/or contain broken links.

Description[edit]

Sets the SQL query string for later execution.

[Edit Descripton]

Template:Description:JDatabase/setQuery

Syntax[edit]

setQuery($sql, $offset=0, $limit=0, $prefix='#__')

Parameter Name	Default Value	Description
$sql		The SQL query
$offset	0	The offset to start selection
$limit	0	The number of results to return
$prefix	'#__'	The common table prefix

Defined in[edit]

libraries/joomla/database/database.php

Importing[edit]

jimport( 'joomla.database.database' );

Source Body[edit]

function setQuery( $sql, $offset = 0, $limit = 0, $prefix='#__' )
{
        $this->_sql             = $this->replacePrefix( $sql, $prefix );
        $this->_limit   = (int) $limit;
        $this->_offset  = (int) $offset;
}

Examples[edit]

API15