Re: DB_FETCHMODE_ASSOC result differs for MySQL and MS-SQL
| From: | Frank M. Kromann | Date: | Tue, 21 Jan 2003 17:57:42 +0000 |
| Subject: | Re: DB_FETCHMODE_ASSOC result differs for MySQL and MS-SQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25016@lists.php.net to get a copy of this message | ||
Hi Gunther,
there was an error in the mssql.php file. I have just fixed that in cvs.
Change line 161 from
$ar = @mssql_fetch_array($result);
to
$ar = @mssql_fetch_array($result, MSSQL_ASSOC);
And it will work on your system
- Frank
> 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
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>