PEAR Manual
Prev |  | Next

# ->limit()

->limit() -- Set limit

## Synopsis

``void $DB_DataObject->limit` ([int $from [, int $number]])`

## Description

Sets the limit for a query. (this only works on databases that support the LIMIT clause), without parameters, it will clear the current limit.

## Parameter

- `int $from` - limit start (or number), or blank to reset

- `int $number` - limit results to number

## Note

This function can not be called statically.

Since postgres and mysql only really support limit directly - calling this on an unsupported database will emit a PEAR::Error and die.

## Example

Example 33-1. Setting the Limit
    $person = new DataObjects_Person;
    $person->limit(2);
    $person->find();
    while ($person->fetch()) {
        echo "{$person->id} {$person->name}<BR>";
    }

    $person = new DataObjects_Person;
    $person->limit(2,4);
    $person->find();

    while ($person->fetch()) {
        echo "{$person->id} {$person->name}<BR>";
    }

Example 33-2. Resulting SQL
    SELECT * FROM person LIMIT 2

    SELECT * FROM person LIMIT 2,4

Prev | Home | Next
->escape() | Up | ->orderBy()