mysql_affected_rows() is very useful function when we need to know how many rows affected our last MySql operation. This function returns the number of affected rows by the last INSERT, UPDATE, REPLACE or DELETE query.
It will return number of rows affected by our last operation & will return -1 if the last query failed. It last query didn’t affect any row of database than it will return 0.
Example :-
<?php
$link = mysql_connect(‘localhost’, ‘milap_patel’, ‘password’);
if (!$link) {
die(‘Could not connect: ‘ . mysql_error());
}
mysql_select_db(‘milap_patel’);
/* this will return the correct numbers of deleted records */
mysql_query(‘DELETE FROM table_name WHERE field_name = “Smile”‘);
printf(“Records deleted: %d\n”, mysql_affected_rows());
?>
Output :-
Records deleted: number of records your query deleted..
Full Stack Web Developer 
I just couldn’t depart your site before suggesting that I really enjoyed the standard information a person provide for your visitors? Is going to be back often to check up on new posts
LikeLike
great !! Can you tell me clearly Whats is the difference between mysql_num_rows() and mysql_affected_rows()?
LikeLike
Hey Liza,
Thanks for your feedback.
mysql_num_rows() is used with SELECT statements while the mysql_affected_rows() is used with UPDATE, DELETE and INSERT statements.
mysql_num_rows() returns the number of rows returned by a SELECT statement & affected_rows returns the number of rows that were altered by a statement that modified the content of a database (insert,update, delete etc).
LikeLike