#36378 [NEW]: mysql_field_table doesn't work with JOIN's

From: troels at kyberfabrikken dot dk Operating system: winxp PHP version: 4.4.2 PHP Bug Type: MySQL related Bug description: mysql_field_table doesn't work with JOIN's Description: ------------ This function only returns the name of the first table when you use a JOIN. Reproduce code: --------------- For example with the query below the table name would be table1 for all fields: SELECT table1.*, table2.this_thing, table3.that_thing FROM table1 LEFT JOIN table2 ON table1.tb2_id = table2.id LEFT JOIN table3 ON table1.tb3_id = table3.id Expected result: ---------------- The expected behaviour would be, that the table name for the field this_thing is table2 and table3 for the field that_thing respectively. -- Edit bug report at http://bugs.php.net/?id=36378&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=36378&r=trysnapshot44 Try a CVS snapshot (PHP 5.1): http://bugs.php.net/fix.php?id=36378&r=trysnapshot51 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=36378&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=36378&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=36378&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=36378&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=36378&r=needscript Try newer version: http://bugs.php.net/fix.php?id=36378&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=36378&r=support Expected behavior: http://bugs.php.net/fix.php?id=36378&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=36378&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=36378&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=36378&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=36378&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=36378&r=dst IIS Stability: http://bugs.php.net/fix.php?id=36378&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=36378&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=36378&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=36378&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=36378&r=mysqlcfg