From: [EMAIL PROTECTED]
Operating system: Linux 2.4 (intel)
PHP version: 4.1.2
PHP Bug Type: MySQL related
Bug description: Feature Request on mysql_fetch_array()
When you SELECT two columns from different tables with the same column name
in a JOIN, you cannot use column names is associative array keys. It would
be really nice when you did something like this:
-------
$result = mysql_query("SELECT tbl1.colA, tbl2.colA FROM tbl1 LEFT JOIN
tbl2 ON tbl1.colB = tbl2.colB");
$row = mysql_fetch_array($result);
-------
if you could then do something like this:
-------
$mydata1 = $row["tbl1.colA"];
$mydata1 = $row["tbl2.colA"];
-------
With the current behavior, you may only access the second array element
with its numerical index.
--
Edit bug report at http://bugs.php.net/?id=16029&edit=1
--
Fixed in CVS: http://bugs.php.net/fix.php?id=16029&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=16029&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=16029&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=16029&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=16029&r=support
Expected behavior: http://bugs.php.net/fix.php?id=16029&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=16029&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=16029&r=submittedtwice
