Hi
Two questions for a php/mysql guru out there 
I need to do two (probably very basic things)
First off after running a query to update multiple lines how would you retrieve how many liens that query effected ? Say you had a column called “name” and you wanted to change all the rows that are currently Dave to Laura how would you find after how many were changed?
Secondly after adding a row to a table with auto increment on a ID field, what would be the easiest way to retrieve the new ID. (assuming some rows may have been previously so count(*) would not give the correct figure but I’m assuming there is a much less painful method on mysql anyway
Thanks in advance,
Oli
