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

ID: 36676 Updated by: mike@php.net Reported By: astro101 at hotmail dot com -Status: Open +Status: Bogus Bug Type: PDO related Operating System: Win XP SP2 PHP Version: 5.1.2 New Comment: Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely to be the same. Thank you for your interest in PHP. Dupe of bug #35386 Previous Comments: ------------------------------------------------------------------------ [2006-03-10 09:11:18] astro101 at hotmail dot com I also found with the latest snapshop (php5.1-win32-200603100330.zip) that i could not connect to the firebird database. ------------------------------------------------------------------------ [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