I am starting a new project, I don’t have a lot of experience and before
running in the wall, I would appreciate to receive your comments :
I have 50 texts (presently in Word format) (one text per month for the past 4
years)
Each text is around 50KB (in .asc format)
These texts have more or less the same shape :
They consist of 10 or 12 chapters which have always the same title (Editorial,
Policy, Programming....,Conclusion)
This could be a template of my texts :
1. Editorial
blablabla.....
2. Policy
blablabla...
3. Programming
blablabla....
...
12. Conclucion
blablabla...
What I want to do :
People shall be able to search online these documents
Search may be done by keywords, date and category may be specified
e.g. : Search words “china” and “sun”,in chapter “policy” only, written after
March 1999.
The list of matching documents shall be display and people can view the
chapters.
To do that, I expect to build the following database :
-----------------------------------------------------------------------
Date of the document |chapter | text
-----------------------------------------------------------------------
1999-02-25 |editorial | blablablabla...........
| |...............................
| |............blbalbal
-----------------------------------------------------------------------
1999-02-25 |policy | blablablabla...........
| |...............................
| |............blbalbal
------------------------------------------------------------------------
What are my concerns :
Is a database done for this kind of thing ?
What is it better :
- to have the text of each chapter in the database (as above)
- to have one file for each chapter and only the adress of the file in the db
To display correctly the text, line breakdown should be kept. Is it possible to
keep them in the database ?
Thanks for your comments.
Pierre
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
