[PHP-DEV] Bug #2758: joined MySQL queries fail From: admin <email protected>
Date: 11/18/99

From: admin <email protected>
Operating system: BSD/OS 4.0 / 4.0.1
PHP version: 3.0.12
PHP Bug Type: MySQL related
Bug description: joined MySQL queries fail

After upgrading PHP from 4.0b2 to 4.02b3, the following MySQL query (which has not changed) no longer works:

select x.name, x.place, y.color, y.shade from locations as x, prefs as y

The error returned is:

Warning: x not found in MySQL result index 7 in mysql.php3 on line 26

Warning: y not found in MySQL result index 7 in mysql.php3 on line 26

Line 26 of mysql.php3 is:

$result = mysql_result($qhandle,$row,$field);

This has not changed either -- it worked yesterday :-)

The problem is reproducible, and is affecting all my php scripts which contain queries structured in the same fashion.

Config/Build options have only changed in one respect from 4.0b2 to 4.0b3; I had to compile with --disable-inline to work around a virtual memory exhaustion problem.

Here's the config line I used to build PHP:

--with-mysql=/usr/local/mysql \
        --with-apache=../apache_1.3.9 \
        --enable-track-vars \
        --disable-inline \
        --with-config-file-path=/var/www/conf 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>