- 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:recordset:fields

# fields

      mixed fields(
            optional int $offset=1
            )

## Description

The function `fields()` returns the value of the column at the specified offset. The offset is always an integer number, beginning at 1. If the offset is negative, or greater than the number of columns obtained through fieldCount(), the value returned is identical to false `===`. If no offset is provided, the value of the first column is returned.

# Usage

    /*
     * DB Connection assumed
     */
    $result = $db->Execute("SELECT * FROM ACT");
    $r = $result->FetchRow();
    print $r->fields(1);
    /*
     * Returns: 10
     */

v5/reference/recordset/fields.txt · Last modified: 2016/01/16 15:44 by mnewnham

### Page Tools

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