#20078 [Bgs->Opn]: Error with left join with mysql_fetch_array()

ID: 20078 User updated by: f.giovannini@netechnologies.it Reported By: f.giovannini@netechnologies.it -Status: Bogus +Status: Open Bug Type: MySQL related Operating System: Linux 2.4.18 PHP Version: 4.2.1 New Comment: Why in the php 4.1.2 is ok? The problem is the value NULL.... it not exist in database... why php retrive an inexistent value Previous Comments: ------------------------------------------------------------------------ [2002-10-25 04:49:07] hholzgra@php.net that's one of the reasons why you should never use 'select * from ...' -> you haven't specified *which* P column you want, A.P or B.P php gives you B.P as P while the cmd line cliebt chose to display A.P ... ------------------------------------------------------------------------ [2002-10-25 04:32:17] georg@php.net Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Thank you for your interest in PHP. If you use mysql_fetch_array with MYSQL_FETCH_ASSOC, be sure that fieldnames are unique. Georg ------------------------------------------------------------------------ [2002-10-25 04:23:20] msopacua@php.net What 'not enough information' meens in this case, is the lack of a short, self contained, copy/paste/run script, so we can try to reproduce the problem. ------------------------------------------------------------------------ [2002-10-25 04:15:21] f.giovannini@netechnologies.it This problem is verified with any mysql version.... $array ------------------------------------------------------------------------ [2002-10-25 04:08:12] derick@php.net 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. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/20078 -- Edit this bug report at http://bugs.php.net/?id=20078&edit=1