例子
常规:
$selectresult = mysql_query("SELECT * FROM table LIMIT 0,100");
$countresult = mysql_query("SELECT count(*) as rowcount FROM table");
......
......
......
使用SQL_CALC_FOUND_ROWS :
$selectresult = mysql_query("SELECT SQL_CALC_FOUND_ROWS * FROM table LIMIT 0,100");
$countresult = mysql_query("SELECT FOUND_ROWS() as count");
$count = mysql_result($countresult ,0);
......
......