mssql_free_result(3) [php man page]

MSSQL_FREE_RESULT(3)													      MSSQL_FREE_RESULT(3)

mssql_free_result - Free result memory

SYNOPSIS

       bool mssql_free_result (resource  $result)

DESCRIPTION

       mssql_free_result(3) only needs to be called if you are worried about using too much memory while your script is running. All result memory
       will automatically be freed when the script ends. You may call mssql_free_result(3) with the result identifier as an argument and the asso-
       ciated result memory will be freed.

PARAMETERS

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

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      mssql_free_result(3) example

	      <?php
	      // Select some data from a table
	      $query = mssql_query('SELECT * FROM [php].[dbo].[persons]', $link);

	      // Handle query result here

	      // When we're done we free the result by calling
	      // mssql_free_result like so:
	      mssql_free_result($query);
	      ?>

SEE ALSO

       mssql_free_statement(3).

PHP Documentation Group 												      MSSQL_FREE_RESULT(3)

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)