Help on Automatic Creation of Dynamic Pages

First post here, great site!

Firstly, check out this site for a basic comprehension of what I'm doing: http://www.seainthecity.net/hard_corals.htm

Ok, here's what I'm trying to do. On that page, you'll see a 3x5 (columns x rows) array of various Hard Corals. Everything on that page is hard coded in HTML. I'm in the process of recreating it with PHP and SQL.

Everything's gone well, but I've run into a hypothetical problem. My friend who runs seainthecity.net would like it to become a very big site. In otherwords, we're worried about expansion problems. At the moment, it automatically grabs whatever's in the hard coral SQL table and displays it all on one page. It's limited to 3 columns, but unlimited rows. Somehow, we'd like it to dynamically create more pages automatically as the table gets bigger. ATM we're looking at a 3x5 array per page. As items are sold, items will be marked SOLD, then eventually removed from the table.

This dynamic creation of new pages, as well as automatic links between pages, has obviously been done before, as seen on almost every bulletin board, including this one, when a thread goes over a certain number of posts per page, or a forum goes over a certain number of threads. Does anyone out there know how to do this?

W H E W! Thanks in advance for the help!