mssql_get_last_message(3) [php man page]

MSSQL_GET_LAST_MESSAGE(3)												 MSSQL_GET_LAST_MESSAGE(3)

mssql_get_last_message - Returns the last message from the server

SYNOPSIS

       string mssql_get_last_message (void  )

DESCRIPTION

	Gets the last message from the MS-SQL server

PARAMETERS

       This function has no parameters.

RETURN VALUES

	Returns last error message from server, or an empty string if no error messages are returned from MSSQL.

EXAMPLES

       Example #1

	      mssql_get_last_message(3) example

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

	      // Make a query that will fail
	      $query = @mssql_query('SELECT * FROM [php].[dbo].[not-found]');

	      if (!$query) {
		  // The query has failed, print a nice error message
		  // using mssql_get_last_message()
		  die('MSSQL error: ' . mssql_get_last_message());
	      }
	      ?>

	      The above example will output something similar to:

	      MSSQL error: Invalid object name 'php.dbo.not-found'.

SEE ALSO

       mssql_min_error_severity(3), mssql_min_message_severity(3).

PHP Documentation Group 												 MSSQL_GET_LAST_MESSAGE(3)

MSSQL_FIELD_LENGTH(3)													     MSSQL_FIELD_LENGTH(3)

mssql_field_length - Get the length of a field

SYNOPSIS

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

DESCRIPTION

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

EXAMPLES

       Example #1

	      mssql_field_length(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], [age] FROM [php].[dbo].[persons]');

	      // Print the field length
	      echo 'The field 'age' has a data length of ' . mssql_field_length($query, 1);

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

	      The above example will output something similar to:

	      The field 'age' has a data length of 4

NOTES

       Note

	      Note to Windows Users

	       Due to a limitation in the underlying API used by PHP (MS DBLib C API), the length of VARCHAR fields is limited to 255. If you need
	      to store more data, use a TEXT field instead.

SEE ALSO

       mssql_field_name(3), mssql_field_type(3).

PHP Documentation Group 												     MSSQL_FIELD_LENGTH(3)