php mysql 影响行数_php更新数据库并返回所影响的行数

$host="mysql153.secureserver.net";

$uname="java2s";

$pass="password";

$database="java2s";

$tablename="Employee";

$connection= mysql_connect($host,$uname,$pass) or die("Database connection failed!
");

$result=mysql_select_db($database) or die("Database could not be selected");

$query = "UPDATE Employee SET Firstname=\"new Name\" where id=2";

$result = mysql_query($query);

if (!$result) {

die(" Query could not be executed.
");

} else {

echo "

echo "

";

echo "

";

echo "

".mysql_affected_rows()." record updated successfully ";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

Name

";

echo "

";

echo "

".$name. "";

echo "

";

echo "

";

echo "

";

echo "

E-mail

";

echo "

";

echo "

".$email. "";

echo "

";

echo "

";

echo "

";

echo "

CustomerID

";

echo "

";

echo "

".$customerid. "";

echo "

";

echo "

";

}

?>