mssql_fetch_assoc

Returns an associative array of the current row in the result (PHP 4 >= 4.2.0, PHP 5, PECL odbtp:1.1.1-1.1.4)
array mssql_fetch_assoc ( resource result_id )

Examples ( Source code ) » mssql_fetch_assoc


<?php

// Send a select query to MSSQL

$query = mssql_query('SELECT [username], [name] FROM [php].[dbo].[userlist]');


// Check if there were any records

if(!mssql_num_rows($query))

{

    echo 'No records found';

}

else

{

    // Print a nice list of users in the format of:

    // * name (username)


    echo '<ul>';


    while($row = mssql_fetch_assoc($query))

    {

        echo '<li>' . $row['name'] . ' (' . $row['username'] . ')</li>';

    }


    echo '</ul>';

}


// Free the query result

mssql_free_result($query);

?>

Code Examples / Notes » mssql_fetch_assoc

[quote] 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 [/quote] the same version PHP 5.2.0

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.

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

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.

regarding 'The 30 character field name limit is still an issue' Thought about using shorter column names and using the description to give more info regarding the column. as to the $result = mssql_query('SELECT articles.id, issues.id FROM articles, issues WHERE articles.pub_date = issues.pub_date'); try this $result = mssql_query('SELECT articles.id as aid, issues.id as iid FROM articles, issues WHERE articles.pub_date = issues.pub_date');

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 ) */ ?>

mssql_fetch_assoc

Returns an associative array of the current row in the result (PHP 4 >= 4.2.0, PHP 5, PECL odbtp:1.1.1-1.1.4) array mssql_fetch_assoc ( resource result_id )

Code Examples / Notes » mssql_fetch_assoc

Change Language

Returns an associative array of the current row in the result (PHP 4 >= 4.2.0, PHP 5, PECL odbtp:1.1.1-1.1.4)
array mssql_fetch_assoc ( resource result_id )