mssql_execute(3) php man page | unix.com

MSSQL_EXECUTE(3)														  MSSQL_EXECUTE(3)

mssql_execute - Executes a stored procedure on a MS SQL server database

SYNOPSIS
       mixed mssql_execute (resource  $stmt, [bool  $skip_results = false])

DESCRIPTION
	Executes a stored procedure on a MS SQL server database

PARAMETERS
	      o $stmt
		- Statement handle obtained with mssql_init(3).

	      o $skip_results
		- Whenever to skip the results or not.

EXAMPLES
       Example #1

	      mssql_execute(3) example

	      <?php
	      // Create a new statement
	      $stmt = mssql_init('NewBlogEntry');

	      // Some data strings
	      $title = 'Test of blogging system';
	      $content = 'If you can read this, then the new system is compatible with MSSQL';

	      // Bind values
	      mssql_bind($stmt, '@author',    'Felipe Pena',  SQLVARCHAR,     false,  false,   60);
	      mssql_bind($stmt, '@date',      '08/10/2008',   SQLVARCHAR,     false,  false,   20);
	      mssql_bind($stmt, '@title',     $title,	      SQLVARCHAR,     false,  false,   60);
	      mssql_bind($stmt, '@content',   $content,       SQLTEXT);

	      // Execute the statement
	      mssql_execute($stmt);

	      // And we can free it like so:
	      mssql_free_statement($stmt);
	      ?>

NOTES
       Note

	       If  the stored procedure returns parameters or a return value these will be available after the call to mssql_execute(3) unless the
	      stored procedure returns more than one result set. In that case use mssql_next_result(3) to shift through the results. When the last
	      result has been processed the output parameters and return values will be available.

SEE ALSO
       mssql_bind(3), mssql_free_statement(3), mssql_init(3).

PHP Documentation Group 													  MSSQL_EXECUTE(3)