ID: 36676
Updated by: [EMAIL PROTECTED]
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
