I need to take a Filename generated by my PHP script and compare it against the name in the "photo_name" field.
The problem, is that my PHP script is just generating...
Whereas in the database I have the full Filename and Extension...
Unfortunately, when I am checking to make sure the new Filename is unique in my PHP Script, I have not determined the MIME type, and so I need a way to do this lopsided comparison, if that makes sense?!
also, is this actually a php question?
If generated Filenames are unique (I'm pretty sure they are), you don't need an extension, you only need to remove the last 4 chars for the value from the field in the database table to make an exact match.