PDO include table name prefixes in FETCH_ASSOC

[email protected] (Aaron Paetznick)
Newsgroups php.db
Organization Critical Distinction, Inc.
Message-ID <[email protected]>
Many of my MySQL tables have columns with the same name.  I want to have 
PDO include table names in named result sets.  For example:

   $sth = $dbh->prepare("SELECT * FROM table0, table1");
   $result = $sth->fetchAll(PDO::FETCH_ASSOC);


I want $result to be organized like:

   echo $result["table0.column0"];
   echo $result["table0.column1"];
   echo $result["table1.column0"];
   echo $result["table1.column1"];


Or, alternatively:

   echo $result["table0"]["column0"];
   echo $result["table0"]["column1"];
   echo $result["table1"]["column0"];
   echo $result["table1"]["column1"];


Any ideas?  Thanks!


--Aaron
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.