Image storage within database or to a indexed directory

[Duncanmcl]

I'm developing a new MySQL DB and have a need to support the import/display of a series of images by user account. Should I design the DB (seperate table)to include images related to this user account or save the image files to a seperate directory with a indexed unique name representing this user account ID. I'm using PHP. The User account will have password/security access.

Can you recommend a good PHP utility to upload/display images from within the application...like a photo album?

Is there a MySQL utility to convert/load an MS Access DB to MySQL directly (structure only..no data)?

Thanks in advance.....Jim

 

[Bastien]

there are a couple of utilities to move from access to mysql...

mysqlfront (

http://mysqlfront.venturemedia.de/)

access to mysql (

http://www.convert-in.com/acc2sql.htm)

access to mysql pro (

http://www.topshareware.com/Access-to-MySQL-Pro-download-975.htm)

just google it and you'll see lots of choices

as for pics in db...i don't recommend it...better to upload pics to folder and store path/name in db as string...better perfomance and simpler to code...

again google for php photo album

hth

Bastien

cat, the other other white meat