Breaking a MySQL "text" record into multiple pages in PHP

MattG

The title may not make much sense but I have a mysql database that contains product reviews everything currently works fine except that I would prefer to breakdown the reviews into multiple pages, is there any easy way to do this with one whole text record in the database or would I need seperate ones for each page?

Hiccup

I'm not sure what you mean. Do you mean for sending to a printer to print out a paper copy?

MattG

Ok if you go here http://www.palgaming.com/reviews.php?id=74 you can see how the reviews output from MySQL currently looks.

I would like to split this review into multiple pages preferably before one of the heading such as Graphics or Audio with a link at the bottom such as "Next Page »" which the visitor will then click to read the rest of the review.

Hope that's a little clearer than my first babble. 😃

Sphynx

What I did was make a review entry page (or pages) and separate the different categories out -- different text box for each category and each labelled. So each category was a separate db field. Reviewers would just fiill out the form, assign a score to each category, and then submit it. It was up to them to fill out the content. Two sentences doesn't cut it :p , then I'd just page on the separate categories with a summary/final rating at the end.

MattG

Thanks for the possible idea Sphynx I'd like to know where this "two sentances" which wouldn't cut it are though 😕