- skip to content

# Database Abstraction Layer

### User Tools

- Login

### Site Tools

- Recent changes
- Media Manager
- Sitemap

### Sidebar

##### Resources

- Reference Manual
- User Guide
- The Data Dictionary
- ADOdb-xmlschema
- ADOdb Active Record
- Performance Monitoring
- Date/Time Library
- Session Management Library
- Unsupported Addons
- Coding Standards

##### Supported Databases

- Access
- ADO
- CSV
- Firebird
- Frontbase
- IBM DB2
- Informix
- Interbase
- LDAP
- Microsoft SQL Server
- MySQL
- Netezza
- ODBC
- ODBTP
- Oracle
- PDO
- Postgresql
- SAP ADS
- SAP ASE
- SAP Maxdb
- SAP Sqlanywhere
- Sqlite
- Sybase
- Plain Text
- Visual Foxpro

##### Other

- Feature Comparison Matrix
- Connection Matrix
- Include File Guide

v5:reference:connection:cacheselectlimit

# cacheSelectLimit

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

##### syntax

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

## 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 selectLimit().

### Usage

    /*
     * 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
    )

    */

[cache]
v5/reference/connection/cacheselectlimit.txt · Last modified: 2016/01/16 16:26 by mnewnham

### Page Tools

- Show pagesource
- Old revisions
- Backlinks
- Rename Page
- Back to top