I want to know what is the difference in between <code>mysql_num_rows</code> and <code>mysql_affected_rows</code>.How to know when it should use.Any help and suggestions will be highly appreciable.Examples are most welcome.

Use <code>mysql_num_rows</code> for <code>SELECT</code> queries while <code>mysql_affected_rows</code> for <code>UPDATE</code> and <code>DELETE</code> queries. <ul> <li> <code>mysql_num_rows</code> tells you how many records were returned from a <code>SELECT</code> query</li> <li> <code>mysql_affected_rows</code> tells you how many rows were <code>UPDATE</code>ed or <code>DELETE</code>ed</li> </ul>

Difference in between mysql_num_rows and mysql_affected_rows

Tags:

mysql

mysqldump

I want to know what is the difference in between mysql_num_rows and mysql_affected_rows.How to know when it should use.Any help and suggestions will be highly appreciable.Examples are most welcome.