#21875 [Opn->Fbk]: mysql_fetch_array delivers wrong result

ID: 21875 Updated by: derick@php.net Reported By: c.bock@qbiz.de -Status: Open +Status: Feedback Bug Type: MySQL related Operating System: Windows 2k / SuSE Linux 7.3 PHP Version: 4.3.0 New Comment: Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. Previous Comments: ------------------------------------------------------------------------ [2003-01-25 06:05:16] c.bock@qbiz.de 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 this bug report at http://bugs.php.net/?id=21875&edit=1