Re: [PHP-DB] PDO include table name prefixes in FETCH_ASSOC

Thanks for the advise.  I wanted a more automatic method of prefixing 
column names, but I ended up just aliasing them all.

I know I could always just issue multiple SELECTs, but I wish MySQL 
would support this sort of functionality natively.  I'd really like to 
reference my results as $result["table0"]["column0"] from a single SELECT.

Anyways, thanks all.


--Aaron


On 3/24/2010 11:28 AM, Niel Archer wrote:
>> 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!
>
> Sounds like you want to UNION two SELECTs
> http://dev.mysql.com/doc/refman/5.0/en/union.html
>
> (SELECT col1, col2, col4 FROM table1 WHERE ... ORDER BY ...)
> UNION
> (SELECT col1, col2, col4 FROM table2 WHERE ... ORDER BY ...)
>
>
>> --Aaron
>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> Niel Archer
> niel.archer (at) blueyonder.co.uk
>
>
>