JDatabaseQueryLimitable::setLimit

Sets the offset and limit for the result set, if the database driver supports it.

Usage: $query->setLimit(100, 0); (retrieve 100 rows, starting at first record) $query->setLimit(50, 50); (retrieve 50 rows, starting at 50th record)

Signature

public function setLimit([integer $limit = 0, [integer $offset = 0]] )

Parameters

$limit

The limit for the result set

$offset

The offset for the result set

Returns

JDatabaseQuery

Returns this object to allow chaining.