Get multiple records with limit clouse

SELECT SQL_CALC_FOUND_ROWS * FROM <tablename> limit 0,10;
SELECT FOUND_ROWS();

$row = mysql_fetch_row(mysql_query(“SELECT FOUND_ROWS()”));
$total = $row[0];

We can get totat records by using above query.

This is for very large records.

This speeds up the query and page execution.

Advertisement