Select the last affected rows

Question

I have updated my records based on specific condition after that I want to know the ids from the affected rows.

$sql = mysqli_query("update table set xxx='".$x."' where yyy='".$y."'");

Now after executing this query I want to know the affected rows.

Answer 1

Simple yet effective

$last_id = mysqli_insert_id($conn);

http://www.w3schools.com/php/php_mysql_insert_lastid.asp