展開全部
1. mysql_num_rows 可得到e69da5e887aa3231313335323631343130323136353331333337383861查詢記錄數<?php
$con?=?mysql_connect("localhost",?"hello",?"321");
if?(!$con)
{
die('Could?not?connect:?'?.?mysql_error());
}
$db_selected?=?mysql_select_db("test_db",$con);
$sql?=?"SELECT?*?FROM?person";
$result?=?mysql_query($sql,$con);
echo?mysql_num_rows($result);
mysql_close($con);
?>
2.?mysql_affected_rows可得到更新影響的記錄數<?php
$con?=?mysql_connect("localhost","mysql_user","mysql_pwd");
if?(!$con)
{
die("Could?not?connect:?"?.?mysql_error());
}
mysql_select_db("mydb");
mysql_query("DELETE?FROM?mytable?WHERE?id?
$rc?=?mysql_affected_rows();
echo?"Records?deleted:?"?.?$rc;
mysql_close($con);
?>
)
