mssql_get_last_message(3) php man page | unix.com

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)