I am having a problem with files on a website where I allow users to upload photos.
Its set up to allow them to upload the photos, and it inserts a filename into a MYSQL database that matches their file name exactly, so a CF variable references the photo they uploaded like www.mysite.com/photos/#filename#
The name matches their file name, unless it has to be renamed to avoid conflict.
I would rather auto-assign unique names & insert that auto-assigned name to the database because frequently their file names contain spaces, or # signs which screws everything up. And also on Linux, part of making it unique is sometimes just changing the filename from .jpg to .JPG which also screws things up...
Is there a way I can make my own system for naming files? I know the system I want to use to create a unique name for each photo, but don't understand how I can attach MY system name to their uploaded photos and insert THAT into the database too?
Does anyone understand what I'm talking about?