mssql_fetch_assoc(3) [php man page]

MSSQL_FETCH_ASSOC(3)													      MSSQL_FETCH_ASSOC(3)

mssql_fetch_assoc - Returns an associative array of the current row in the result

SYNOPSIS

       array mssql_fetch_assoc (resource  $result_id)

DESCRIPTION

	Returns an associative array that corresponds to the fetched row and moves the internal data pointer ahead. mssql_fetch_assoc(3) is equiv-
       alent to calling mssql_fetch_array(3) with MSSQL_ASSOC for the optional second parameter.

PARAMETERS

	      o $result_id
		- The result resource that is being evaluated. This result comes from a call to mssql_query(3).

RETURN VALUES

	Returns an associative array that corresponds to the fetched row, or FALSE if there are no more rows.

EXAMPLES

       Example #1

	      mssql_fetch_assoc(3) example

	      <?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);
	      ?>

PHP Documentation Group 												      MSSQL_FETCH_ASSOC(3)