计算带限制的结果数

Question

How do I count number of results with limits? Obviously the code I have is not correct. Any help?

$result = mysqli_query ($conn, "select SQL_CALC_FOUND_ROWS * from $sql $limit");
$db_count = mysqli_query ("SELECT FOUND_ROWS()");

ANSWER: $sql = "$db_name.$db_table $where $where_search $db_sort"; $result = mysqli_query ($conn, "select * from $sql $limit"); $rec = mysqli_fetch_array(mysqli_query($conn, "SELECT COUNT(*) as totalCount FROM $sql")); $db_count = $rec['totalCount'];