php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #2758 joined MySQL queries fail
Submitted: 1999-11-18 19:12 UTC Modified: 2000-07-22 19:20 UTC
From: admin at i-1 dot net Assigned:
Status: Closed Package: MySQL related
PHP Version: 3.0.12 OS: BSD/OS 4.0 / 4.0.1
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: admin at i-1 dot net
New email:
PHP Version: OS:

 

 [1999-11-18 19:12 UTC] admin at i-1 dot net
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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-07-22 19:20 UTC] mrobinso at cvs dot php dot net
Bug report against php4 showing version 3.0.12.
Please reopen with correct version of problem persists.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Sat Jul 12 05:01:33 2025 UTC