Number of Rows Affected by a SQL Statement in PHP

Q

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

✍: FYIcenter.com

A

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.

 

Inserting Data into a Table in PHP

Creating a Table in PHP

Working with MySQL Database in PHP

⇑⇑ PHP Tutorials

2016-10-20, 1696🔥, 0💬