How can I count the numbers of rows that a mysql query returned?

Blog Admin February 23, 2018

Solution:

use SQL_CALC_FOUND_ROWS in your query, followed by SELECT FOUND_ROWS();

Example:

SELECT SQL_CALC_FOUND_ROWS * FROM transactionhead;
SELECT FOUND_ROWS();

Example:

Universal Info वेलकम