#35386 [NEW]: first row is null

From: Date: Fri, 25 Nov 2005 10:38:33 +0000
Subject: #35386 [NEW]: first row is null
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-88919@lists.php.net to get a copy of this message
From: slapaf at hotmail dot com Operating system: winxp sp2 PHP version: 5.1.0 PHP Bug Type: PDO related Bug description: first row is null 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 bug report at http://bugs.php.net/?id=35386&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=35386&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=35386&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=35386&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=35386&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=35386&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=35386&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=35386&r=needscript Try newer version: http://bugs.php.net/fix.php?id=35386&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=35386&r=support Expected behavior: http://bugs.php.net/fix.php?id=35386&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=35386&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=35386&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=35386&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=35386&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=35386&r=dst IIS Stability: http://bugs.php.net/fix.php?id=35386&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=35386&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=35386&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=35386&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=35386&r=mysqlcfg

« previous php.bugs (#88919) next »