Posted by J.O. Aho on 02/07/06 03:23

Tony Peardon wrote:
> Hi,
>
> I'm building an online project manager. Within my database, I have a table
> named projects which stores data about various projects. For each project, I
> require an overview, which could be as short as a single sentence, or as
> long as multiple paragraphs, so what is the best way of storing a project
> overview?
>
> I was thinking that the table could store a file name, and then PHP could
> open that file, but that seems like a work-around, rather than a solution.
> There must be a better way, but what is it?

Store the text in the database, you can use the type TEXT for the column.
If you store things in a file, you need to make a directory where you store
the text files writable for the webserver, which lowers in general the
security of the system and you need to have code to verify that the file is
there and is readable. You get a lot less job just working with the database.



//Aho

[Back to original message]