Page 1 of 1

PHP MySQL file upload question

Posted: Tue Jun 16, 2009 3:41 pm
by jmcc
I have a standard form that retrieves user data and stores it in a MySQL table.

If I want to store multiple photos for each user what is the best way to go about this?

Re: PHP MySQL file upload question

Posted: Tue Jun 16, 2009 3:51 pm
by Eric!
I would build a table which contains the user and then information on the photos:
user,description,filetype,path/to/file/filename

Then you can just sort based on users, descriptions or filetype (jpg,png,etc). You could add other crap like a field for user ranking, number of clicks...blah blah.