count rows mysql limit php code example

Example 1: count rows mysql limit php

SELECT SQL_CALC_FOUND_ROWS id, title FROM foo LIMIT 5;

Example 2: count rows mysql limit php

SELECT FOUND_ROWS();