showing number of row

This function that you required is called paging.

Paging means showing your query result in multiple pages instead of just put them all in one long page.MySQL helps to generate pagingby using LIMIT clause which will take two arguments. First argument as OFFSET and second argument how many records should be returned from the database.

Look at the below link for your reference

http://www.techumber.com/2012/08/simple-pagination-with-php-mysql.html?m=1

---------------------------------------------------

Accept the answer if it helps

----------------------------------------------------