How do I find the number of rows affected by a query?
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.
More mysql PHP Questions
How do I set a default value for ENUM fields in PHP?How do I return a random row from the database?
How do I find second highest value from a table?
How do I limit the number of rows returned?
How do I connect to mySQL from PHP?