Hi
I'm looking for some advice. I want to store large amounts of text for creating dynamic content. Some of the data required for the pages is quite generic and can easily be stored in a database, however the main body of content can differ from record to record. Each can have different sections, headings, diagrams etc. What would be the most appropriate method for storing this data? At the moment i'll be working with php mySql, but eventually this content will be in a CMS, but i'll still want to offer a filter of sorts.
Is it possible to keep the generic details in a db with a link to an xml document with the main content? Should i seperate each section into tables and add tables as i come across new sections?
Any ideas would be appreciated.
R