I need to update and NOT insert url if the image is not updated. The rest is working

What is working:
1. Image will update and insert http://hotlinewebsites.com/userfiles/6336/myfile.jpg into the database
a. With 6336 being the id from tbl_directorylistings or from the session variable depending on the page.
2. Image will upload into appropriate folder
3. Image file name will be appended if the file is duplicate
Issue: If an image existing and you simply update the page the existing image will no longer display properly as the url gets inserted again.

FTP and more details are in the attachment. Thank You!

I updated line 77 to address this issue. Basically I strip off the file name from the default value of the upload, so that when it adds the full url to the front it won't be repeated.

Let me know if you still have any issues.

I am having a similiar issue, likely on the same page, but now we have updated to MySQLI. Page is attached.
Line # 122 of update query or the obvious upload params at the top of the page.

I have revised the upload directory from 2022 to 2023 and if the record is updated it changes the file directory to 2023 resulting in a broken path IF the original record was created using the 2022 file directory AND a new file is not uploaded.

Right now the user has to go back and upload the flyer again and we end up with it BOTH in the 2022 directory and the 2023 directory and an unpleasant experience for the user.

The solution is probably pretty easy, but I don't quite understand what you need. I'll be working tomorrow if you want to call we can do a quick call. I'm sure it will just take a few minutes once I understand it.