Re: PDO Prevent duplicate field names?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Jul 3, 2012 at 12:25 AM, Scott Baker <bakers@xxxxxxxxxxxx> wrote:
> $sql = "SELECT First, Last, Age, 'Foobar' AS Last;";
>
> This is a simplified example of a SQL query where we're returning two
> fields with the same name (Last). When I do a fetch_assoc with this
> query I only get three fields, as the second "Last" field over writes
> the first one.
>
> I was hoping there was some method with PDO that would detect that and
> throw a warning. Maybe some sort of "strict mode" that would tell me I'm
> doing something stupid. Is there a way to catch this before it bites me?
>
> It already bit me, but moving forward it'd be nice if PHP saw that
> before I spent an hour debugging it again.
>
> - Scott
>

Why the #### would you want to return 2 columns with the same name?
To be short, there's no such function, so you have to:
1) Rename one of the columns
2) or, use fetch_row with numerical indexes instead of fetch_assoc.

- Matijn

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux