#36378 [Fbk->Csd]: mysql_field_table doesn't work with JOIN's

ID: 36378 User updated by: troels at kyberfabrikken dot dk Reported By: troels at kyberfabrikken dot dk -Status: Feedback +Status: Closed Bug Type: MySQL related Operating System: winxp PHP Version: 4.4.2 New Comment: My appologies - This problem seems to have been fixed- Copied the text from the comments section of http://php.net/mysql_field_table. I wonder why it was never filed as a bug in the first place ? Would anyone happen to know from which version this was working properly ? Previous Comments: ------------------------------------------------------------------------ [2006-02-13 15:23:03] tony2001@php.net Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If possible, make the script source available online and provide an URL to it here. Try to avoid embedding huge scripts into the report. ------------------------------------------------------------------------ [2006-02-13 15:17:36] troels at kyberfabrikken dot dk 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 this bug report at http://bugs.php.net/?id=36378&edit=1