mssql_rows_affected(3) php man page | unix.com

MSSQL_ROWS_AFFECTED(3)													    MSSQL_ROWS_AFFECTED(3)

mssql_rows_affected - Returns the number of records affected by the query

SYNOPSIS
       int mssql_rows_affected (resource  $link_identifier)

DESCRIPTION
	Returns the number of records affected by the last write query.

PARAMETERS
	      o $link_identifier
		- A MS SQL link identifier, returned by mssql_connect(3) or mssql_pconnect(3).

RETURN VALUES
	Returns the number of records affected by last operation.

EXAMPLES
       Example #1

	      mssql_rows_affected(3) example

	      <?php
	      // Delete all rows in a table
	      mssql_query('TRUNCATE TABLE [php].[dbo].[persons]');

	      echo 'Deleted ' . mssql_rows_affected($link) . ' row(s)';
	      ?>

PHP Documentation Group 												    MSSQL_ROWS_AFFECTED(3)