php mysql_affected_rows获取sql执行影响的行数

mysql_affected_rows介绍

mysql_affected_rows 取得最近一次INSERT，UPDATE 或 DELETE 查询所影响的记录行数。

语法：

mysql_affected_rows( _identifier)

参数： 

mysql_affected_rows实例

<?php
   mysql_connect(\"mysql153.secureserver.net\",\"root\",\"password\");
   mysql_select_db(\"manongjc\");

   $query = \"UPDATE Employee SET salary = \'39.99\' \";
   $result = mysql_query($query);
   echo \"There were \".mysql_affected_rows().\" product(s) affected. \";

?>