Database Structure Question

[skipcollege]

Hi, I am working on a html form processing script that will handle text info as well as multiple file uploads. It will store the locations to the uploaded files in a mysql database. The users may upload 0, 1, 2, 3, 4, 5 etc. files - whatever they choose. So the information that will need to be stored in the db is a name, email, phone number, message, and possibly multiple upload locations - number will be different for each submission.

I am confused on what the table structure should be in the database in order to accommodate the possibility of multiple upload locations.

Thanks.

[Roger_Ramjet]

Seperate tables, one for the user info and one for the file info: eg

users
user_id autoinc
name char
email char
phone char
message text

files
file_id autoinc
user_id int
file_name char
location char
date_in date

[skipcollege]

Thanks Roger! I was so close.