PHP: mssql_fetch_assoc - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

mssql_fetch_batch mssql_fetch_array

Last updated: Fri, 26 Jan 2007

view this page in

# mssql_fetch_assoc

(PHP 4 >= 4.2.0, PHP 5)

mssql_fetch_assoc -- Returns an associative array of the current row in the result set specified by result_id

## Description

array mssql_fetch_assoc ( resource result_id )

Внимание
К настоящему времени эта функция еще не была документирована; для ознакомления доступен только список аргументов.

add a note User Contributed Notes
mssql_fetch_assoc
jbarker at erepublic dot com
24-Jan-2007 09:35
`Beware when using mssql_fetch_assoc() to return data pulled in from joined tables; if the tables have the same column names, the column mentioned last will overwrite the prior one when populating the assoc.
Example:
<?
$result = mssql_query('SELECT articles.id, issues.id FROM articles, issues WHERE articles.pub_date = issues.pub_date');
$record = mssql_fetch_assoc($result);
print_r($record);
/*
Prints:
Array
(
[id] => 123
)
*/
?>`
brandonkirsch at uses dot gmail dot domain
11-Dec-2006 10:43
`We are running FreeTDS on a Linux Apache / PHP server and encountered the following error when calling mssql_fetch_assoc()
Fatal error: Call to undefined function mssql_fetch_assoc()
We were confused because *some* of the mssql commands worked, such as mssql_connect and mssql_fetch_array. The trick to make mssql_fetch_assoc() work lies in configuring FreeTDS. We had to change the statement to contain the --enable-msdblib switch:
./configure --enable-msdblib
We then recompiled PHP to include --with-mssql=/path/to/freetds and finally mssql_fetch_assoc() began working properly.`
ben at thelocust dot org
03-Nov-2006 12:22
`The 30 character field name limit is still an issue as of PHP 5.1.6, at least running under IIS.`
electricsurfer.com
01-Dec-2003 08:38
`WARNING:
PHP 4.3.4 introduced a BUG.
if the DB has: '' (empty string)
this function will return: ' ' (string with 1 space)
see: http://bugs.php.net/bug.php?id=26315`
php at electricsurfer dot com
03-Jun-2003 11:34
`WARNING: as of PHP 4.3.2
The keys in the array will only contain the 1st 30 characters of the column name if you have column names longer than that.`
add a note
mssql_fetch_batch mssql_fetch_array

Last updated: Fri, 26 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 10:36:09 2007 PST