Elegant Solution Required.

[tommmmm]

I plan to allow users to upload up to x photos y at a time. I have an upload form that works and uploads one file at a time which I will just add more fields to the form, what would be the best way to upload only non-blank fields (the user might fill out field 1 and 3 and not 2)

At the moment I check to see how many pics the user has uploaded with an sql query then if that is < 60 allow the upload. So I would like to avoid running this query each time there is an upload.

The only way I can think to do this is to do an sql query and get the $photos_uploaded then if < 60 allow uploads. Then everytime there is a succesfull upload add 1 to $photos_uploaded and check it is less than 60 each time.

This does not seem like an elegnt solution to the problem. I would appreciate some suggestions on how best to achieve this.

Thanks in advacne.

[jdorsch]

There is nothing wrong with running a query to check the number uploaded each time. Writing a file to disk causes a lot more overhead than doing a simple select query, so its a drop in the ocean.

As for the blanks, just check to see if the file name is blank, if it is skip it.