$sql = 'select count(*) as num from TableName'; $num = mysql_fetch_assoc(myslq_query($sql));#您可以简化该查询,如$db->XXX $total = $num['num'];#$total即为行数