Description: ------------ While testing some code using the ifx driver, i noticed that fetchRow() returned the same row everytime it was called. I went to the file ifx.php and changed the call to "ifx_fetch_row" in the "fetchInto" method: line 227: if (!$row = @ifx_fetch_row($result, $rownum)) { to if (!$row = @ifx_fetch_row($result, "NEXT")) { I am pretty sure this is not the way to solve it but it is what i did untill there is an official bugfix. Reproduce code: --------------- [...] $dsn = "ifx://user:pass@host/dbname"; [...] while ($row = $result->fetchRow()){ echo $row['id'].'<br>'; } Expected result: ---------------- 16<br> 17<br> 18<br> 19<br> 20<br> 21<br> Actual result: -------------- 16<br> 16<br> 16<br> 16<br> 16<br> 16<br> 16<br> 16<br> 16<br> 16<br> 16<br> (untile time out is reached)

peterw was unable to duplciate. Is in direct communication with the reporter.

Can you please apply this patch and let me know what happens? Index: ifx.php =================================================================== RCS file: /repository/pear/DB/DB/ifx.php,v retrieving revision 1.24 diff -u -r1.24 ifx.php --- ifx.php 19 Jan 2004 20:10:39 -0000 1.24 +++ ifx.php 22 Jan 2004 19:50:30 -0000 @@ -232,7 +232,9 @@ if (($rownum !== null) && ($rownum < 0)) { return null; } - // if $rownum is null, fetch row will return the next row + if ($rownum === null) { + $rownum = 'NEXT'; + } if (!$arr = @ifx_fetch_row($result, $rownum)) { return null; }

The patch above was applied to CVS. Tests indicated that this didn't break anything and probably resoles the users issue.