在mySQL中使用LIMIT进行COUNT的SQL查询

Question

In php-mysql, how to count number of rows returned within a SELECT query?
let's think of the SELECT query something like this:

$q = "SELECT * from users LIMIT 20,60"

But if total number of records was just for example 55, The results is users from 20 to 55 with a total number of 35 not 40!
How can I have the number 35 without querying the DB twice?
now I am doing like this:

$q = "SELECT COUNT(*) from users LIMIT 20, 60";
$result = mysqli_query($db_connection, $1);
$count = mysqli_fetch_row($result);
$count = $count[0];

But here I am querying the DB twice and I think this is not so good.
I know that I could have the total number of rows without considering the LIMIT, using SQL_CALC_FOUND_ROWS and FOUND_ROWS(), but this is not my case, as I want to consider the LIMIT.
Thanks!

Answer 1

You want to num_rows

$count = $result->num_rows;