Adding files to a MySQL database

[ErikZ]

Most of my working knowledge comes from Access, so if this isn't an issue with MySQL, be kind.

I plan on making a web-based story archive. I'm trying to figure out how to link the story files to the MySQL database. In Access you can link to a file outside of the database. Is this possible in MySQL? Or is it so stable I can just add the whole story file?

I'd prefer to have all my stories in a separate directory and link to them from the MySQL database. Is there an example of this or a tutorial anywhere?

 

[FrdPrefct]

I'd assume, you can have the SQL db store a reference to a link (file) that is stored in flat file space. Then, just use the reference to the link in your scripts for the webpage.

 

[NixerX]

Try to use the Binary data type..I've never used it before but I have heard good things!
-NixerX

 

[ErikZ]

actually, I just put in the path and the name of the file.
I'm making this web-based so I also added the href to it. Works great!

Well, except for titles that have a ' in them. Those I edit by hand.