Help generate more pagesin same page?

What Im trying to do is I am reading info from mysql however my content box is not long enough to display all the data so what I wanna do is split the pages so that you can click a link called Next and go to the next page which will display more of the info im getting from the mysql

Im rusty when it comes to php so I wont know what you would call this so its hard to explain.

Basicly You have Page 1 Click Next link and go to Page 2 and so on.

well what kind of information is going to be displayed? Is it going to be like a list of rows, or like one row with (for example) a long story?

I think what your looking for is called 'paging' or 'pagination', here is a really good tutorial:

http://www.php-mysql-tutorial.com/php-mysql-paging.php