How can I find the number of rows affected by a sql query?

Question

I have a number of INSERT and UPDATE statements in a MySQL Stored Procedure, that works in the form of START TRANSACTION followed by COMMIT. Also I am handling any EXCEPTION.

However, after calling COMMIT, how can I get the number of Rows that were affected either INSERTED or UPDATTED ?

Answer 1

The function you will want, is mysql_affected_rows which you call after the query has run, and it will tell you how many rows were affected.

Example:
$qry="update table_name set column_3=somevalue where column_2=somevalue;
$exeqry="mysql_query($qry);
$affectedrows=mysql_affected_rows($exeqry);