[PHP-DEV] PHP 4.0 Bug #3350: wrong results from sybase_fetch_row and sybase_fetch_array From: jl543 <email protected>
Date: 01/29/00

From: jl543 <email protected>
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.

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>