Can I get fully qualified column names with pdo?

[iansmith]

Using the PDO fetch functions with PDO::FETCH_ASSOC gets you an array keyed on the column names.

 

This is a problem if you have multiple tables with the same column names. 

 

Is there any way to have it return the table and column name?  Otherwise I need to do long lists of 'as' names in my SELECTs.

 

Thanks!