PHP 4.0 Bug #3350: wrong results from sybase_fetch_row and sybase_fetch_array
| From: | jl543 at hotmail dot com | Date: | Sat, 29 Jan 2000 23:00:25 +0000 |
| Subject: | PHP 4.0 Bug #3350: wrong results from sybase_fetch_row and sybase_fetch_array | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-15040@lists.php.net to get a copy of this message | ||
From: jl543@hotmail.com
Operating system: Redhat 6.0
PHP version: 4.0 Beta 3
PHP Bug Type: Sybase (dblib) related
Bug description: wrong results from sybase_fetch_row and sybase_fetch_array
This bug is making 4.0Beta 3 unusable with sybase for me.
Please advice on a workaround!!
I have a simple table like this:
create table UserInfo
(
uID numeric(10,0) not null,
userName varchar(32) not null,
passwd char(38) null ,
constraint PK_USERINFO primary key (uID)
)
With the following php code, I get wrong passwd out
1 out of every 5 times or so.
$q= sybase_query("select uID,userName,passwd
from UserInfo where userName='$username'", $dblink);
while($qarray = sybase_fetch_row($q)) {
echo $qarray[2];
$pass = $qarray[2];
echo $pass;
}
----
results:
$qarray[2] is always correct;
$pass is wrong 1/5 of the times.
The behavior is similiar if I use sybase_fetch_array.