Differences

This shows you the differences between two versions of the page.

--- v5:reference:connection:setfetchmode [2016/02/09 01:44] – mnewnham
+++ v5:reference:connection:setfetchmode [2018/06/11 10:18] – [Usage] function names starting with lowercase (#426) dregad
@@ Line 27: / Line 27: @@
 <code php>
 $db->setFetchMode(ADODB_FETCH_NUM);
+$rs1 = $db->execute('select * from table');
-$rs1 = $db->Execute('select * from table');
 $db->setFetchMode(ADODB_FETCH_ASSOC)
+$rs2 = $db->execute('select * from table');
-$rs2 = $db->Execute('select * from table');
 print_r($rs1->fields);
@@ Line 46: / Line 44: @@
 </code>
+====== Fetch Both =====
+Some databases support a 'Fetch Both' mode. In this mode, the value are returned as both a numeric and an associative array, interspersed.
+<code php>
+shows _array([0]=>'v0',
+             ['col1']=>'v0',
+             [1] =>'v1',
+             ['col2']=>'v1'
+             )
+</code>
+This mode can be set using ''ADODB_FETCH_MODE''