1.

How To Get The Number Of Rows Selected Or Affected By A Sql Statement?

Answer»

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

  • mysql_num_rows($rs) - 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.

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


Discussion

No Comment Found

Related InterviewSolutions