PHP: mysql_affected_rows - Manual - PHP: Hypertext Preprocessor

Notes Note: Transactions If you are using transactions, you need to call mysql_affected_rows() after your INSERT, UPDATE, or DELETE query, not after the COMMIT. Note: SELECT Statements To retrieve the number of rows returned by a SELECT, it is ...

php.net