spliting large mysql

[markinbrighton]

I am a relative newbie to php programming but have so far managed to build some quite complex sites, however this stumps me.

 

I'm creating a website to display pieces of writing a writing group

I have set up a MySQL database, with, amongst others, a large

field that contains the actual piece of writing. The writing is stored

as text in a medium blob.

 

My problem is that some of the pieces of writing are quite large and

need to be displayed over several pages. However, I don't know how to split a single field over several pages.

 

Obviously the repeat region, which has the recordset paging, will not

work but I was wondering if it would be altered and using some php functions to count the words or lines and a loop to create the pagination.

 

Can anyone explain how to do this? Or are there any extensions or

articles that might help?

 

 

Many thanks