MSSQL_FIELD_TYPE(3)													       MSSQL_FIELD_TYPE(3)

mssql_field_type - Gets the type of a field

SYNOPSIS

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

DESCRIPTION

	Returns the type 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 type of the specified field index on success or FALSE on failure.

EXAMPLES

       Example #1

	      mssql_field_type(3) example

	      <?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 [name] FROM [php].[dbo].[persons]');

	      // Print the field type and length
	      echo ''' . mssql_field_name($query, 0) . '' is a type of ' .
		   strtoupper(mssql_field_type($query, 0)) .
		   '(' . mssql_field_length($query, 0) . ')';

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

	      The above example will output something similar to:

SEE ALSO

       mssql_field_length(3), mssql_field_name(3).

PHP Documentation Group 												       MSSQL_FIELD_TYPE(3)