Hi,

I'm working on implementing file uploads and am wondering how you would like to see it work. Here's how I am thinking of doing it:

There will be a file upload box in the admin add screen and admin add error screen only. The admin can then when adding a new record, upload an attached file. The database stores only the filename, and the admin script puts all the files in a preset directory. The files are renamed to ID.extension where extension is whatever it was when the file was uploaded.

When modifying, the admin can not re upload the file. This might cause problems when you need to modify a record and don't want to upload a new file. So if the admin needs to change the file, they need to use FTP.

Users can attach a file when adding a link, and that file is saved in a non viewable upload directory. It is subsequently moved over to the viewable directory when it is validated.

If a user modifies a record, they can upload a new file, but it will still be held in the validation bin waiting to be approved.

Any comments/ideas? =)

Cheers,

Alex