mssql_field_name(3) [php man page]

MSSQL_FIELD_NAME(3)													       MSSQL_FIELD_NAME(3)

mssql_field_name - Get the name of a field

SYNOPSIS

       string mssql_field_name (resource  $result, [int  $offset = -1])

DESCRIPTION

	Returns the name of field no. $offset in $result.

PARAMETERS

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

	      o $offset
		- The field offset, starts at 0. If omitted, the current field is used.

RETURN VALUES

	The name of the specified field index on success or FALSE on failure.

EXAMPLES

       Example #1

	      mssql_field_name(3) example

	      <?php
	      // Send a select query to MSSQL
	      $query = mssql_query('SELECT [username], [name], [email] FROM [php].[dbo].[userlist]');

	      echo 'Result set contains the following field(s):', PHP_EOL;

	      // Dump all field names in result
	      for ($i = 0; $i < mssql_num_fields($query); ++$i) {
		  echo ' - ' . mssql_field_name($query, $i), PHP_EOL;
	      }

	      // Free the query result
	      mssql_free_result($query);
	      ?>

	      The above example will output something similar to:

	      Result set contains the following field(s):
	       - username
	       - name
	       - email

SEE ALSO

       mssql_field_length(3), mssql_field_type(3).

PHP Documentation Group 												       MSSQL_FIELD_NAME(3)

MSSQL_RESULT(3) 														   MSSQL_RESULT(3)

mssql_result - Get result data

SYNOPSIS

       string mssql_result (resource  $result, int  $row, mixed  $field)

DESCRIPTION

       mssql_result(3) returns the contents of one cell from a MS SQL result set.

PARAMETERS

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

	      o $row
		- The row number.

	      o $field
		-  Can be the field's offset, the field's name or the field's table dot field's name (tablename.fieldname). If the column name has
		been aliased ('select foo as bar from...'), it uses the alias instead of the column name.

	      Note

		      Specifying a numeric offset for the $field argument is much quicker than specifying a fieldname or tablename.fieldname argu-
		     ment.

RETURN VALUES

	Returns the contents of the specified cell.

EXAMPLES

       Example #1

	      mssql_result(3) example

	      <?php
	      // Send a select query to MSSQL
	      $query = mssql_query('SELECT [username] FROM [php].[dbo].[userlist]');

	      // Check if there were any records
	      if (!mssql_num_rows($query)) {
		  echo 'No records found';
	      } else {
		  for ($i = 0; $i < mssql_num_rows($query); ++$i) {
		      echo mssql_result($query, $i, 'username'), PHP_EOL;
		  }
	      }

	      // Free the query result
	      mssql_free_result($query);
	      ?>

	      The above example will output something similar to:

	      Kalle
	      Felipe
	      Emil
	      Ross

       Example #2

	      Faster alternative to above example

	      <?php
	      // Send a select query to MSSQL
	      $query = mssql_query('SELECT [username] FROM [php].[dbo].[userlist]');

	      // Check if there were any records
	      if (!mssql_num_rows($query)) {
		  echo 'No records found';
	      } else {
		  while ($row = mssql_fetch_array($query)) {
		      echo $row['username'], PHP_EOL;
		  }
	      }

	      // Free the query result
	      mssql_free_result($query);
	      ?>

NOTES

       Note

	       When  working  on  large result sets, you should consider using one of the functions that fetch an entire row (specified below). As
	      these functions return the contents of multiple cells in one function call, they're MUCH quicker than mssql_result(3).

SEE ALSO

	Recommended high-performance alternatives: mssql_fetch_row(3), mssql_fetch_array(3), mssql_fetch_assoc(3), mssql_fetch_object(3).

PHP Documentation Group 													   MSSQL_RESULT(3)