PDO Prevent duplicate field names?
| From: | Scott Baker | Date: | Mon, 02 Jul 2012 22:25:06 +0000 |
| Subject: | PDO Prevent duplicate field names? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-318376@lists.php.net to get a copy of this message | ||
$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