PDO: fetchAll() with duplicate column name on JOIN

Question

I have several table with similar column name in my database.

Let say TABLE 1, TABLE 2, TABLE 3 have a column named : "name". Those are not indexed columns. They contain different and independant data.

If I run a query joining these 3 tables and fetchAll() the results, there will be only one "name" entry in the resulting array since fetchAll() overwrite the column with the same name.

The regular MySQL Library let you access such results doing:

mysql_result($result,0,'TABLE1.name');

How can I let PDO append the table name before the column name like : TABLE1.name, TABLE2.name, etc.

I want to AVOID using alias in my SQL query since I have tons of tables. The only answers I found online uses alias. Is there any parameters we can feed to PDO to do what I am looking for?

Afaik, you'll have to use PDO::FETCH_NUM & use the number of the column, or FETCH_BOUND with ->bindColumn(), again with the number based index. — Wrikken
It's in PHP's docs, although var_dump()-ing the results of ->fetchAll(PDO::FETCH_NUM) & examining it's output will probably tell you enough to work with it. — Wrikken

vcampitelli vcampitelli · Accepted Answer · 2013-05-07T19:28:47

You can use aliases instead of direct column names in your SELECT statement. Something like this:

SELECT
  table1.name AS t1_name,
  table2.name AS t2_name,
  table3.name AS t3_name
-- rest of your query

PDO: fetchAll() with duplicate column name on JOIN

1 Answers