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
