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_FIELD_SEEK(3)													       MSSQL_FIELD_SEEK(3)

mssql_field_seek - Seeks to the specified field offset

SYNOPSIS

       bool mssql_field_seek (resource	$result, int  $field_offset)

DESCRIPTION

	Seeks to the specified field offset. If the next call to mssql_fetch_field(3) won't include a field offset, this field would be returned.

PARAMETERS

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

	      o $field_offset
		- The field offset, starts at 0.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Using mssql_field_seek(3) on the example for mssql_fetch_field(3)

	      <?php
	      // Connect to MSSQL and select the database
	      mssql_connect('MANGOSQLEXPRESS', 'sa', 'phpfi');
	      mssql_select_db('php');

	      // Send a select query to MSSQL
	      $query = mssql_query('SELECT * FROM [php].[dbo].[persons]');

	      // Construct table
	      echo '<h3>Table structure for 'persons'</h3>';
	      echo '<table border="1">';

	      // Table header
	      echo '<thead>';
	      echo '<tr>';
	      echo '<td>Field name</td>';
	      echo '<td>Data type</td>';
	      echo '<td>Max length</td>';
	      echo '</tr>';
	      echo '</thead>';

	      // Dump all fields
	      echo '<tbody>';

	      for ($i = 0; $i < mssql_num_fields($query); ++$i) {
		  // Fetch the field information, notice the
		  // field_offset parameter is not set. See
		  // the mssql_field_seek call below
		  $field = mssql_fetch_field($query);

		  // Print the row
		  echo '<tr>';
		  echo '<td>' . $field->name . '</td>';
		  echo '<td>' . strtoupper($field->type) . '</td>';
		  echo '<td>' . $field->max_length . '</td>';
		  echo '</tr>';

		  // Move the internal seek pointer to the next
		  // row in the result set
		  mssql_field_seek($query, $i + 1);
	      }

	      echo '</tbody>';
	      echo '</table>';

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

SEE ALSO

       mssql_fetch_field(3).

PHP Documentation Group 												       MSSQL_FIELD_SEEK(3)