This is an old revision of the document!

$ADODB_FETCH_MODE

Type	Integer
Default	0

Do not confuse with the setFetchMode() function

This is a global variable that determines how arrays are retrieved by recordsets. The recordset saves this value on creation (eg. in Execute or SelectLimit), and any subsequent changes to $ADODB_FETCH_MODE have no affect on existing recordsets, only on recordsets created in the future.

Constants

Name	Value	Description
ADODB_FETCH_DEFAULT	0	The recordset is returned in the default provided by the PHP driver. Use of this value is not recommended if writing cross-database applications
ADODB_FETCH_NUM	1	The recordset is returned as a numeric array
ADODB_FETCH_ASSOC	2	The recordset is returned as an associative array
ADODB_FETCH_BOTH	3	The record is returned as both a numeric and associative arrays

Syntax

$ADODB_FETCH_MODE = ADODB_FETCH_NUM;