======
UPDATE TableName SET FieldName=FieldValue
WHERE FieldName=FieldValue;
SELECT ROW_COUNT() AS 'Affected Rows';
ROW_COUNT() is function for get affected rows...
SQLServer
=========
UPDATE TableName SET FieldName=FieldValue
WHERE FieldName=FieldValue;
SELECT @NumberRowsChanged=@@ROWCOUNT;
@@ROWCOUNT is global variable for get affected rows...
PHP
===
The ===
ROW_COUNT function is the mysql_affected_rows equivalent in MySQL.
