[UPHPU] Some Database setup help

[District Webmaster]

Have you considered storing the image in the database? This helps with
data portability and some security issues. You would want a blob field
to store an image.

Dave

>>> "Ashley Oviatt" <ashovi at qwest.net> 05/20/04 11:15 AM >>>
I'm setting up a MySQL database to store file locations (of images) that

will be used in a pdflib application.

The php page will have to look into the database for the file location 
(all on the local server, this is an internal process at this point) and

then tell the location to pdflib according to what month it is/which 
image it is supposed to use/which logo it is supposed to use/ etc.

My question is what is the best way to set up the database to do that? 
As in what types of fields should I use? Mediumtext? int? varchar?

And what fields should I include besides just id and maybe timestamp? I 
need some of the images to link to another user table (ie. a picture of 
a person and their logo needs to be linked to the person's contact data 
in another table in the same db.)

Thanks,

Ashley



---------------------------------------------------------------------
To unsubscribe, e-mail: list-unsubscribe at uphpu.org
For additional commands, e-mail: list-help at uphpu.org