DB_FETCHMODE_ASSOC result differs for MySQL and MS-SQL
| From: | Gunther | Date: | Sat, 18 Jan 2003 10:17:24 +0000 |
| Subject: | DB_FETCHMODE_ASSOC result differs for MySQL and MS-SQL | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-3337@lists.php.net to get a copy of this message | ||
I have a problem with PHP 4.3.0, latest PEAR running under w2k with either
MySQL or MS-SQL. With MySQL everything is fine, running the same application
just
changing the DB server to MS-SQL I get different results.
I am using fetchRow(DB_FETCHMODE_ASSOC) to get my DB rows.
Under MySQL (correct) a row would look like this:
'fieldname' => value (e.g. [whateverfield] => 9 )
Under MS-SQL I get:
0 => value 'fieldname' => value (e.g. [0] => 9 [whateverfield] => 9 )
It seems that under MS-SQL DB_FETCHMODE_ASSOC AND DB_FETCHMODE_ORDERED
are both on at the same time.
Any ideas how I get this working ...?
Gunther