====== fetchRow =====
~~NOTOC~~
<WRAP right box>
== Syntax ==
  mixed fetchRow()
</WRAP>
===== Description =====
The function ''fetchRow()'' returns the current row of a recordset as an array or false if past end-of-file and advances the pointer of the result. If the end-of-file is reached, the ''EOF'' attribute is set 

Results are influenced both by the [[v5:reference:adodb_assoc_case|ADODB_ASSOC_CASE]] constant and [[v5:reference:adodb_fetch_mode|$ADODB_FETCH_MODE]] attribute
-------------------
===== Usage =====
<code php>
/*
 * Database connection assumed
 */
$SQL = "SELECT * FROM act"
$result = $db->execute($SQL);
while($r = $result->fetchRow())
    print_r($r);
/*
 * Array returns
Array(
    [0] => 10,
    [1] => ROW 1
    )
    .....
*/
</code>
{{tag>[PEAR]}}