Quick question about how i should go about this

[pinehead18]

Ok, i have a script coded now that can upload a file and does everything i need. However, i'm looking some direction from the community.

What i need to be able to do is allow each person to have the ability to upload 3 pictures each.

What is the best way to go about this?

What i was thinking is that i create 3 fields in the db. one for each picture url.

Then in order to upload a file.. You click on one of the links IE. PIcture 1 - Picture 2 - PIcture 2 and the upload script will allow you to upload the url to the specific field per the id and the picture to the /pictures file.

Is this the best way to handel it?

Thank you for your input.
- Anthony

[rpanning]

Maybe just have a field in the db that records how many times a user has uploaded a pic. Every time they upload a pic the counter increments one so when it reaches 3 they can't upload anymore. That way if you ever want to adjust the max number of uploadable images you can do it in PHP rather than editing the db table. Just a thought.

[pinehead18]

Don't i have to use the sql fields to store the url of the image.. So i can pull them on the html page?

[rpanning]

I havn't worked a whole lot with databases yet but maybe make a table that keeps track of all uploaded pictures. Like with two fields, user and url. Maybe an uploaded order field to to keep track of their upload order..?? Ex:

User        Order      URL
-----------------------------
rpanning    1    /pics/mypic1.jpg
rpanning    2    /pics/me.jpg
pinehead    1    /pics/mydog.jpg
rpanning    3    /pics/mylogo.gif
pinehead    2    /pics/itsme.jpg

I don't know, just another thought. I'm sure someone else here who has worked with DB's more will have a better answer than I.