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

ID: 36378 Updated by: tony2001@php.net Reported By: troels at kyberfabrikken dot dk -Status: Open +Status: Feedback Bug Type: MySQL related Operating System: winxp PHP Version: 4.4.2 New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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