is this the most effective way of creating a CMS

[gwx03]

I would like to have a data-oriented website, which would be known as Knowledgespace. Is there any other method which is more efficient than my current method? Also, I believe that this method would not work in the long-run as the formatting is rather rigid and cannot be changed. It follows a predetermined structure.

My idea is there would be a page "cp.php" which lists all the Articles available for viewing in a table. This "cp.php" page obtains data from a MySQL database which contains the following columns : Serial No., Title, First para, second para, third para, dl_available_1, dl_availabe_2, and so on.

Then when the user clicks on an article in "cp.php", they would be given the article ( more information ). It would then request other data such as the first para, second para, etc, and input these data into the respective pre-created DIV tags.

However, what I want ultimately is a structure which can be edited, such as that of www.wikipedia.org. How would that be possible. Would there be another method besides my method of echoing data retrived from the mysql database?? Given that I want to finish this by the end of next month ( and I put effort in it ), can I code all the code myself? Or do I require to go for pre-created third-party scripts at hotscripts.com?

[Rob]

Why not store the entire article in either a memo field, or indeed in an html or xml document?

I wouldn't piss around with seperate fields for each para....thats just ridiculous.

Integrate a web-based WYSIWYG html editor (use a java one if you aint editing / adding content from IE)

[courtjester]

Yeah use the memo field or the xml document. It would be much easier. I have learned to love memo fields. :wink:

[gwx03]

oh ok. I didn't know about it actually ??: but did some reading and found that the equivalent in mysql ( nchar, nvarchar )