#35386 [Opn]: first row is null

ID: 35386 User updated by: slapaf at hotmail dot com Reported By: slapaf at hotmail dot com Status: Open Bug Type: PDO related Operating System: winxp sp2 PHP Version: 5.1.0 New Comment: deleting row with "name 1" and inserting a "name 5" returns: NULL : string : name 3 string : name 4 string : name 5 Previous Comments: ------------------------------------------------------------------------ [2005-11-25 11:48:44] slapaf at hotmail dot com array(2) { ["EVENT_NAME"]=> NULL [0]=> NULL } array(2) { ["EVENT_NAME"]=> string(6) "name 2" [0]=> string(6) "name 2" } array(2) { ["EVENT_NAME"]=> string(6) "name 3" [0]=> string(6) "name 3" } array(2) { ["EVENT_NAME"]=> string(6) "name 4" [0]=> string(6) "name 4" } ------------------------------------------------------------------------ [2005-11-25 11:44:58] tony2001@php.net Change this line: print '<pre>'.gettype($row['EVENT_NAME']).' : '.$row['EVENT_NAME']; to var_dump($row); and paste the result here. ------------------------------------------------------------------------ [2005-11-25 11:38:32] slapaf at hotmail dot com Description: ------------ When using PDO for simple query in Firebird it returns first row as null. I've tried using ADODB for control and it returns the correct results. Reproduce code: --------------- $dbh = new PDO("firebird:dbname=localhost:test.fdb","****","******"); $sql='SELECT EVENT_NAME FROM EVENTS'; foreach($dbh->query($sql) as $row){ print '<pre>'.gettype($row['EVENT_NAME']).' : '.$row['EVENT_NAME']; } Expected result: ---------------- string : name 1 string : name 2 string : name 3 string : name 4 Actual result: -------------- NULL : string : name 2 string : name 3 string : name 4 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=35386&edit=1