website design question multi-user system

[john_20_28_2000@yahoo.com]

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]

Re: website design question multi-user system

On 5 Feb 2005 10:32:00 -0800, john_20_28_2000 @yahoo.com wrote:
[color=blue]
>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.[/color]

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 / <andy@andyh.co. uk> / <http://www.andyh.co.uk >
<http://www.andyhsoftwa re.co.uk/space> Space: disk usage analysis tool