Bug #61758 [Opn->Wfx]: mysql_fetch_field() incorrectly reports table name when using a table alias
Edit report at https://bugs.php.net/bug.php?id=61758&edit=1
ID: 61758
Updated by: johannes@php.net
Reported by: johnbillion at gmail dot com
Summary: mysql_fetch_field() incorrectly reports table name
when using a table alias
-Status: Open
+Status: Wont fix
Type: Bug
Package: MySQL related
Operating System: Windows 7
PHP Version: 5.3.10
Block user comment: N
Private report: N
New Comment:
Please use mysqli and mysqli_fetch_field() instead of the old mysql extension. The old MySQL
extension only receives bug fixes no new "features". mysqli will report two fields,
"table", which has the aliased name, and "origtable", which has the original
name.
Previous Comments:
------------------------------------------------------------------------
[2012-04-18 03:27:30] phpmpan at mpan dot pl
You have introduced an alias for a table in your query and the result contents reflects this. There
is a good reason for such behaviour. Consider a following query:
SELECT *
FROM SomeTable AS workers
JOIN SomeTable AS managers ON managers.id = workers.boss
------------------------------------------------------------------------
[2012-04-17 19:03:31] johnbillion at gmail dot com
Description:
------------
The value of the 'Table' property returned by mysql_fetch_field() will be incorrect if a
table alias was used in the SQL query.
Test script:
---------------
// It's assumed a MySQL resource has been established here
$result = mysql_query( 'SELECT * FROM table AS t' );
$i = 0;
while ( $i < mysql_num_fields( $result ) ) {
$col_info[] = mysql_fetch_field( $result );
$i++;
}
echo '<pre>' . print_r( $col_info, true ) . '</pre>';
Expected result:
----------------
The 'Table' property of the object output should be 'table'.
Actual result:
--------------
The 'Table' property of the object output is 't'.
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=61758&edit=1
Thread (3 messages)