Re: mysql: edit mutliple forms with one submit button

[Trimbach]

It's worth noting that MySQL will optimize UPDATEs so that it won't update a field to a value that's already stored in that field... UPDATE table SET name="John Smith" WHERE id=1 will turn into a no-op if name is already set to "John Smith".

Unless your user list is very very long it might be a good idea to just update every field for every record every time "submit" is pressed. I suspect the performance impact will be minimal, and you don't have to mess with JavaScript or anything hinky like that.

Gary Blackburn
Trained Killer

[Arien]

UPDATE table SET name="John Smith" WHERE id=1 will turn into a no-op if name is already set to "John Smith".

For very flexible values of no-op.

— Arien