Jump to content


Photo

spliting large mysql


  • Please log in to reply
No replies to this topic

#1 markinbrighton

markinbrighton
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 26 August 2005 - 09:12 PM

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





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users