php 用count（*）无法获取sql总数

Question

$rowCount;
$rowCountSql="select count(*) as count from leavelword";
$rowCount=mysql_query($rowCountSql);
echo $rowCount;
输出结果：Resource id #4 

Answer 1

$rowCount;
$rowCountSql="select count(*) as count from leavelword";
$rowCount=mysql_query($rowCountSql); 
$rw=mysql_fetch_row($rowCount);
echo $rw[0];

Answer 2

例子
$sql = "SELECT count(pid) pid  FROM activity";
$query = mysql_query($sql);
$rs = mysql_fetch_array($query);
echo $rs['pid']."条（查看）";

Answer 3

$total=mysql_query("select count(*) from leavelword");
$rowCount=mysql_fetch_array($total); //shuzu
$num=$rowCount[0]; //记录总数
echo $num;