#41416 [Fbk->Opn]: getColumnMeta() should also return table name
| From: | fabrizio dot balliano at crealabs dot it | Date: | Thu, 17 May 2007 14:29:26 +0000 |
| Subject: | #41416 [Fbk->Opn]: getColumnMeta() should also return table name | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-112745@lists.php.net to get a copy of this message | ||
ID: 41416
User updated by: fabrizio dot balliano at crealabs dot it
Reported By: fabrizio dot balliano at crealabs dot it
-Status: Feedback
+Status: Open
Bug Type: Feature/Change Request
PHP Version: 5.2.2
New Comment:
actually i don't have a test script...
just run something like
select * from table1 join table2 on (table1.id=table2.id)
the resultset wouldn't allow me to know with field come from table1 or
table2, thus you call eg:
getcolumnmeta(5)
and you should also get table_name=>table1 or table2 or whatever
Previous Comments:
------------------------------------------------------------------------
[2007-05-17 14:23:22] tony2001@php.net
I'm going to look into it and I would like to have a test script handy.
I guess you already have one, please provide it, so that I wouldn't have
to spend time on it.
Thank you.
------------------------------------------------------------------------
[2007-05-17 14:16:37] fabrizio dot balliano at crealabs dot it
there's no need for test scripts, point just is that calling
getColumnMeta() should return the table name of the column
------------------------------------------------------------------------
[2007-05-17 14:10:34] 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 the script requires a
database to demonstrate the issue, please make sure it creates
all necessary tables, stored procedures etc.
Please avoid embedding huge scripts into the report.
------------------------------------------------------------------------
[2007-05-17 13:25:17] fabrizio dot balliano at crealabs dot it
Description:
------------
if you run a query with joins is really useful to have the
getcolumnmeta to return the table name thus I can understand from the
resultset with field come from every table
now it's possible to do that with
http://it.php.net/manual/it/function.mysql-tablename.php
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=41416&edit=1