On Tue, Jul 3, 2012 at 12:25 AM, Scott Baker <bak...@canbytel.com> 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.
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php