PHP 5, mysql - I am trying to figure the best way around handling empty fields on updates. So if a field were left empty it wouldnt overwrite existing data stored in that specific row in database.
In my case I am having troubles handling updates where a file upload is part of the form. Does anyone know if turning off the visibility via some DOM practices will make it not register on the POST? Then I could have a button where it could say like change file or something and user could click that and change the visibility to alter it, else it wouldnt be included on the update submit if not.
I was also thinking about wrapping the whole update in a conditional if statement. What are some best practices for handling updates and empty fields and overwriting?
MT