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