selectLimit

The order of the $rowsToReturn and $startOffset variables may not match the order specified in the underlying PHP function

syntax
 mixed selectLimit(
       string $sql,
       optional int $rowsToReturn=-1,
       optional int $startOffset=-1,
       optional string[] $bindvars=false
       }

Description

The function executes a statement, and returns a handle to a recordset or false if the statement execution fails.

The presentation of the returned data can be modified by:

For a detailed description of the $sql and $bindvars parameters passed, see execute().

$rowsToReturn

$rowsToReturn indicates the maximum number of rows for the request to return. If End-Of-File is reached, the number returned may be less. If the value is -1, then all rows starting at the requested offset are returned. selectLimit() executed with -1 rows and -1 offset is the same as execute().

$startOffset

$startOffset indicates the nth row at which to start the request. Row numbers start at 0. If the row number is beyond End-Of-File then an empty recordset will be returned.

Usage

/*
 * DB2 Connection assumed
*/
$SQL = "SELECT * FROM act";
$result = $db->selectLimit($SQL,2,3);
while ($r = $result->fetchRow())
    print_r($r);
 
/*
 * Returns 2 rows starting at offset 3 (4th record starting at 0)
 
 
Array
(
    [0] => 40
    [1] => LEADPR
    [2] => LEAD PROGRAM/DESIGN
)
Array
(
    [0] => 50
    [1] => SPECS
    [2] => WRITE SPECS
)
 
*/