Home > PHP > Function > MySQL > mysql_affected_rows()

mysql_affected_rows()

mysql_affected_rows - Get number of affected rows in previous MySQL operation

Syntax

int mysql_affected_rows (resource $link_identifier)

Arguments

  • link_identifier - The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect() is assumed. If no such link is found, it will try to create one as if mysql_connect() was called with no arguments. If no connection is found or established, an E_WARNING level error is generated.

Description

Get the number of affected rows by the last INSERT, UPDATE, REPLACE or DELETE query associated with link_identifier.

Version

PHP 4, 5

Return value

Returns the number of affected rows on success, and -1 if the last query failed.