展开全部
PHP查询语句,e69da5e6ba903231313335323631343130323136353331333337626231有两种方法获得查询的总记录数。
一是使用mysql_num_rows函数,例子代码:<?php
$link = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database", $link);
$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);
echo "$num_rows Rows\n";
?>
二是修改查询语句,使用COUNT(*)作为查询内容,例子代码:<?php
$link = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database", $link);
$result = mysql_query("SELECT COUNT(*) FROM table1", $link);
list($num_rows) = mysql_fetch_row($result);
echo "$num_rows Rows\n";
?>