Simple way to update using dynamic attribute
On a results page for a particular POST, I have a drop down list of all employees that are associated with an event using the eventID.
I chose each employee that will be assigned to this post and when I add them, a employeePost table is updated giving this employee a postID. That drop down list filters out rows where the employee has a postID so that we can tell which employees have not been assigned to a post yet.
You can see how this works betters using the images attached.
I'm looking for the best way to handle removing an employee from the POST and adding them back to the list. I know that I need to update the DB row to change the postID to either zero or NULL but I think that there is probably a better and cleaner way to do this then how I added them to the DB in the first place (if this makes sense).
I'm including the main and supporting page. I can provide a URL and login details if needed. I tried creating a removePersonnel.php page and basically replicating the same from that created the postID update in the first place but I made it too complicated and think there should be a better way.