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?
PHP MySQL file upload question
Moderator: General Moderators
Re: PHP MySQL file upload question
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.
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.