Problem: I have a databse of items. Each item has an id, name, and type. At times I need to change the types on a number of items. Rather then going into my database management tool and changing each item one at a time, I would like all the items to appear in a table with one editable box (type) for each record where I can change all the ones requiring a change, click a button, and have the form update each record that has changed.
I can easily get the data and display it in a table with each row having the id, name, and an editable box showing the current type. I can go to each record and change the type but when I click the Submit button it only updates the first record in the database or doesnt update anything at all. I have a suspition that I need to add all the changed values in the form to an array of some kind and loop thru the array and update each one independently. However, im so brain wracked from this process I cant figure out where to start.
Thanks in advance.