How do I find the number of rows affected by a query?

With mysql it is usually just a case of learning which function to use, and this is no exception.

The function you will want is mysql_affected_rows which you call after the query has run, and it will tell you how many rows were affected.

Comment on this Question and Answer >>>

ASK A QUESTION

More mysql PHP Questions

the uploading status shows success but not showing in the server is empty the written php file is first gave warning cannot uploaded warning in foreach loop but i corrected mistake by keeping above if condition and no error status shows success upload b

How do I limit the number of rows returned?

I need to test database time needed to execute scryp (like 10 000 inputs) with what command i can start measuring time, start scrypt, and then to stop time when scrypt is done and get time resault?

how can I show an image from mysql?

How do I find second highest value from a table?