CODE EXAMPLE FOR PHP

count rows mysql limit php

SELECT SQL_CALC_FOUND_ROWS id, title FROM foo LIMIT 5;