====== cacheSelectLimit ======
~~NOTOC~~
<WRAP info>
The order of the ''$rowsToReturn'' and ''$startOffset'' variables may not match the order specified in the underlying PHP function
</WRAP>
<WRAP right box>
== syntax ==
   mixed cacheSelectLimit(
         mixed $cacheSeconds,
         optional string $sql=-1,
         optional int $rowsToReturn=-1,
         optional int $startOffset=-1,
         optional string[] $bindvars=false
         }
</WRAP>

===== Description =====
Cache functions search for the results of an executed query in the query cache. The results of a query have an expiration time specified by either the first parameter, if that parameter is a positive integer, or the value of 
''$db->cacheSecs'' if not. If an unexpired cache result is not found, the query is cached for the specified period.

For an explanation of the syntax of the other parameter of ''cacheSelectLimit()'', see [[v5:reference:connection:selectlimit|selectLimit()]].

==== Usage ====
<code php>
/*
 * DB2 Connection assumed
*/
$SQL = "SELECT * FROM act";
$result = $db->cacheSelectLimit(3000,$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
)

*/
            
</code>
{{tag>[cache]}}