#21875 [NEW]: mysql_fetch_array delivers wrong result

From: c.bock@qbiz.de Operating system: Windows 2k / SuSE Linux 7.3 PHP version: 4.3.0 PHP Bug Type: MySQL related Bug description: mysql_fetch_array delivers wrong result I have a small table, having only two columns (id + name). For keeping my PHP code general, i executed the following SQL Statement: "select name, id, 1 from tablename" The Result was: +----+------+---+ | id | name | 1 | +----+------+---+ | 1 | 1 | 1 | | 2 | 1 | 1 | | 3 | 1 | 1 | | 4 | 1 | 1 | +----+------+---+ Later on, i tried the same statement with 0 instead of 1, and the id was all set to 0. The workaraound, i found was writing "select name, id, 1 as type from tablename", which worked fine for me. I've checked, if mySQL delivers a correct result and it does. I have not checked, if this is a general database problem. Thanks in advance and keep up the great work! -- Edit bug report at http://bugs.php.net/?id=21875&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=21875&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=21875&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=21875&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=21875&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=21875&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=21875&r=support Expected behavior: http://bugs.php.net/fix.php?id=21875&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=21875&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=21875&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=21875&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=21875&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=21875&r=dst IIS Stability: http://bugs.php.net/fix.php?id=21875&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=21875&r=gnused