This is an old revision of the document!

$ADODB_FETCH_MODE

Type	Integer
Default	0

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. Not supported in many databases

Syntax

$ADODB_FETCH_MODE = ADODB_FETCH_NUM;  
 
$rs1 = $db->Execute('select * from table');  
 
$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;  
 
$rs2 = $db->Execute('select * from table');  
 
print_r($rs1->fields); 
/*
  shows _array([0]=>'v0',
               [1] =>'v1')
*/
print_r($rs2->fields); 
/*
 * shows _array(['col1']=>'v0',
                ['col2'] =>'v1')
 */

More Information

For more information on the constants used and for more granular control of this setting, see setFetchMode()