note 47349 added to function.mysql-field-table

From: 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

« previous php.notes (#80440) next »