showing number of row

Question

Hi how to let few or more rows only show in php when you select data from MySQL. like the one in phpmyadmin how you select number of rows to show when there are more data in a table

Mohammed Adamu · Answer

Ok man thanks a lot I will look into it and inform you well thanks man

Amit Gupta · Answer

Hi 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 paging by 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 ----------------------------------------------------