I have run into a problem where I need to update multiple rows in an SQL table at once. I have found and tried to use the tutorials on setting an ID and then looping through the data that way (http://www.daniweb.com/forums/thread35096.html) but my setup is a little different:
The table would look something like this:
ID | ItemName | Owner
0 | test | me
1 | test2 | you
2 | tester | me
Note how the ID number does NOT go in a sequence with the owner.
I need to ONLY edit data based on the owner (the owner being who is logged in).
I haven't been able to make that happen, if someone could help me out it would be appreciated.