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'];