Uzaren.com

Total number of rows in MySQL query.

Execute 2 queries:

SELECT SQL_CALC_FOUND_ROWS name, email FROM users WHERE name LIKE 'a%' LIMIT 10;

-- Directive SQL_CALC_FOUND_ROWS is required

SELECT FOUND_ROWS();

-- Returns total number of rows in previous query where name LIKE 'a%'. Can be more than limitation of 10.

In php+mysql you must execute 2 different queries. NOT all in ONE.