From: sm at grand-prix dot ru
Operating system: Linux RedHat 9
PHP version: 4.3.1
PHP Bug Type: MySQL related
Bug description: Some data lost in returned array by mysql_fetch_array
Description:
------------
In some cases mysql_fetch_array returns numbered array element, but
does'nt returns it's named copy.
This script was tested as a part of vbulletin's code.
Bug: in the first case $user[userid] is empty, but $user[0] contains
correct data. For other user - 2'nd case - all is OK. Behavior depends
from data, returned by mysql.
Reproduce code:
---------------
$query_string = "SELECT *,FROM_UNIXTIME(joindate) AS
joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity)
AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,
avatar.avatarpath,NOT
ISNULL(customavatar.avatardata) AS hascustomavatar
FROM user
LEFT JOIN avatar ON
avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON
customavatar.userid=user.userid
WHERE user.userid=412";
$res = mysql_query($query_string,$link_id);
$user = mysql_fetch_array($res);
print_r($user);
$query_string = "SELECT *,FROM_UNIXTIME(joindate) AS
joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity)
AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,
avatar.avatarpath,NOT
ISNULL(customavatar.avatardata) AS hascustomavatar
FROM user
LEFT JOIN avatar ON
avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON
customavatar.userid=user.userid
WHERE user.userid=287";
$res = mysql_query($query_string,$link_id);
$user = mysql_fetch_array($res);
print_r($user);
Expected result:
----------------
Array (
[0] => 412
[userid] => 412
[1] => 6
[usergroupid] => 6
[2] => SM_1
[username] => SM_1
.......
Array (
[0] => 287
[userid] => 287
[1] => 6
[usergroupid] => 6
[2] => SM
[username] => SM
.......
Actual result:
--------------
Array (
[0] => 412
[userid] =>
[1] => 6
[usergroupid] => 6
[2] => SM_1
[username] => SM_1
.......
Array (
[0] => 287
[userid] => 287
[1] => 6
[usergroupid] => 6
[2] => SM
[username] => SM
.......
--
Edit bug report at http://bugs.php.net/?id=24879&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=24879&r=trysnapshot4
Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=24879&r=trysnapshot5
Fixed in CVS: http://bugs.php.net/fix.php?id=24879&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=24879&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=24879&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=24879&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=24879&r=support
Expected behavior: http://bugs.php.net/fix.php?id=24879&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=24879&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=24879&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=24879&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=24879&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=24879&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=24879&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=24879&r=gnused
