~~NOTOC~~ 
====== $ADODB_FETCH_MODE ======

<WRAP right 200px box>
== See Also ==
[[v5:reference:connection:setfetchmode]]
== Definition ==
|Type|Integer|
|Default|0|

</WRAP>

This is a global variable that determines how the **keys** of recordsets are presented when recordsets are retrived from the database. The recordset saves this value on creation (eg. in [[v5:reference:connection:execute]] or [[v5:reference:connection:selectlimit]]), and any subsequent changes to $ADODB_FETCH_MODE have no affect on existing recordsets, only on recordsets created in the future.

** This variable has no effect on the data returned, only the keys of data **

----------------------------

===== 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 =====

<code php>
$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')
 */

</code>

===== More Information =====
For more information on the constants used and for more granular control of this setting, see [[v5:reference:connection:setfetchmode|setFetchMode()]]