website design question multi-user system

[john_20_28_2000]

Hi, I will be using MySQL as the database to manage a website where
users can upload images and files. I am not real sure how to create
the database for this. Should I have a main account that the code uses
in the background or should I have it so that each user creates a real
MySQL account and just retrieve information based upon who is logged
in? Thank you.

[Andy Hassall]

On 5 Feb 2005 10:32:00 -0800, jo*************@yahoo.com wrote:

Hi, I will be using MySQL as the database to manage a website where
users can upload images and files. I am not real sure how to create
the database for this. Should I have a main account that the code uses
in the background or should I have it so that each user creates a real
MySQL account and just retrieve information based upon who is logged
in? Thank you.

More often than not, a single MySQL user with one table for the images, with a
field indicating which user the image belongs to is the appropriate way to go.

--
Andy Hassall / <an**@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool