Sets the limit for a query. (this only works on databases that support the LIMIT clause), without parameters, it will clear the current limit.
int $from - limit start (or number), or blank to reset
int $number - limit results to number
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 39-1. Setting the Limit
Example 39-2. Resulting SQL