You can call the mysql_stmt_affected_rows() function to return the number of rows modified, deleted, or inserted by the last UPDATE, DELETE, or INSERT statement.
Syntax
my_ulonglong
mysql_stmt_affected_rows(MYSQL_STMT *stmt)
Errors
None.
Notes
You can call mysql_stmt_affected_rows() immediately after executing a statement by calling mysql_stmt_execute(). It is similar to mysql_affected_rows() but it is used only for prepared statements.