note 47349 added to function.mysql-field-table
| From: | doelling_at_publicform_dot_de at osu1 dot php dot net | Date: | Fri, 12 Nov 2004 15:08:43 +0000 |
| Subject: | note 47349 added to function.mysql-field-table | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-80440@lists.php.net to get a copy of this message | ||
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.
----
Manual Page -- http://www.php.net/manual/en/function.mysql-field-table.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+47349
Delete -- http://master.php.net/manage/user-notes.php?action=delete+47349&report=yes
Reason: bad code -- http://master.php.net/manage/user-notes.php?action=delete+47349&report=yes&reason=bad+code
Reason: spam -- http://master.php.net/manage/user-notes.php?action=delete+47349&report=yes&reason=spam
Reason: useless example -- http://master.php.net/manage/user-notes.php?action=delete+47349&report=yes&reason=useless+example
Reason: contains commercial links -- http://master.php.net/manage/user-notes.php?action=delete+47349&report=yes&reason=contains+commercial+links
Reason: useless note -- http://master.php.net/manage/user-notes.php?action=delete+47349&report=yes&reason=useless+note
Reject -- http://master.php.net/manage/user-notes.php?action=reject+47349&report=yes
Search -- http://master.php.net/manage/user-notes.php