How many rows updated in mysql 1

[saroy71]

Hi all,

I am doing an update in php and it works great but I need to know how many rows were updated. I know if I put the query directly into phpmyadmin it will tell me '10 rows updated successfully'. Is there a way to get that information from the database back to my web site page?

Thanks in advance,
Scott

 

[sleipnir214]

Check out the PHP function mysql_affected_rows()


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[saroy71]

works perfect.

thanks!