How To Get the Number of Rows Selected or Affected by a SQL Statement?

There are two functions you can use the get the number of rows selected or affected by a SQL statement:

• mysql_num_rows($res) - Returns the number of rows selected in a result set object returned from SELECT statement.
• mysql_affected_rows() - Returns the number of rows affected by the last INSERT, UPDATE or DELETE statement.