You wrote a search engine that should retrieve 10 results at a time, but at the same time you'd like to know how many rows there're total. How do you display that to the user?
By Balu Prasad
You wrote a search engine that should retrieve 10 results at a time, but at the same time you'd like to know how many rows there're total. How do you display that to the user?
Teacher SiliconIndia replied to Balu Prasad Thursday, March 18, 2010
Hi Balu,
SELECT SQL_CALC_FOUND_ROWS page_title FROM web_pages LIMIT 1,10; SELECT FOUND_ROWS(); The second query (not that COUNT() is never used) will tell you how many results there're total, so you can display a phrase "Found 13,450,600 results, displaying 1-10". Note that FOUND_ROWS does not pay attention to the LIMITs you specified and always returns the total number of rows affected by query.
