note 47349 deleted from function.mysql-field-table by tony2001
| From: | tony2001@php.net | Date: | Mon, 13 Feb 2006 15:45:03 +0000 |
| Subject: | note 47349 deleted from function.mysql-field-table by tony2001 | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-103629@lists.php.net to get a copy of this message | ||
Note Submitter: doelling_at_publicform_dot_de
----
Similarly to the behaviour described by cptnemo this function returns only the name of the first
table when you use a JOIN.
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
The expected behaviour would be, that the table name for the field this_thing is table2 and table3
for the field that_thing respectively.