#36676 [Opn]: PDO resultset for Firebird does not return 1st row values

ID: 36676 User updated by: astro101 at hotmail dot com Reported By: astro101 at hotmail dot com Status: Open Bug Type: PDO related Operating System: Win XP SP2 -PHP Version: 5.1.3RC1 +PHP Version: 5.1.2 New Comment: I also found with the latest snapshop (php5.1-win32-200603100330.zip) that i could not connect to the firebird database. Previous Comments: ------------------------------------------------------------------------ [2006-03-10 08:09:15] astro101 at hotmail dot com Description: ------------ When querying a firebird database with pdo the values returned for the 1st row of the resultset are empty. If you change your order or delete a entry the 1st row values still return nothing. Reproduce code: --------------- $db = new PDO ("firebird:dbname=localhost:c:/mydb.fdb", 'SYSDBA', 'masterkey'); try{ $query = 'select * from HandsetsMake;'; $res = $db->query($query); while($row = $res->fetch(PDO::FETCH_NUM)){ echo 'Result: '.$row[0].'<br />'; } $cms->commit(); }catch (Exception $e){ echo 'caught exeption: '.$e->getLine().$e->getMessage(); } Expected result: ---------------- Result:1 Result:2 Result:3 Result:4 Actual result: -------------- Result: Result:2 Result:3 Result:4 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=36676&edit=1