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

ID: 20078 Updated by: georg@php.net Reported By: f.giovannini@netechnologies.it -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: Linux 2.4.18 PHP Version: 4.2.1 New Comment: As I told you before, it's not a bug in PHP, it's the expected result. Please visit http://www.php.net/support.php or http://www.mysql.com/documentation/lists.html Georg Previous Comments: ------------------------------------------------------------------------ [2002-10-25 05:44:01] f.giovannini@netechnologies.it 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 ------------------------------------------------------------------------ [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 ------------------------------------------------------------------------ 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