I am writing a script where the user has a list printed out of a MySQL database on the screen that has selection boxes next to each item on the list, each selection box has choice of "Territories" they can choose from. At the bottom of the screen the user has a submit button which says "Assign Cases".
My problem is when user hits submit button "Assign Cases", I want my program to update each record (THAT HAD A SELECTION MADE) with the territory selected.
If a territory was not selected next to one of the items, then the program will do nothing.
Update Multiple Records
Moderator: General Moderators