Updating more than one record at the same time

[Anon]

This is not as ilogical as it sounds. I need to display the content of 10 records in editable textboxes. The user have to update them and when finished, he clicks the submit button and the 10 records have to be updated. Any ideas? Suggestions about a related website?

Thanks

[Anon]

OK, if 9 out of 10 of the changes occur, do you want all 9 to be rolled back, or is it better to get 90% right and just keep going?

Either way, you need to build a single form that has the data in it in such a way you can easily parse it back out. I'd suggest using arrays to do it, so that the first record would be the 0 subscript, the second 1, and so on. Your input fields could look something like this:

<input type=text name=form_var[0]["lname"]>
<input type=text name=form_var[0]["fname"]>
...
<input type=text name=form_var[9]["country"]>

etc...

If you to ensure that all the changes are done at once, then enclose the 10 update statements you'll need in begin/end commands. Note, if you are using mysql, handling transactions is something you'll have to take care of, or run the beta version that supports transactions.

[Anon]

Sounds like a good idea. I'll try it that way, thnaks a lot.

Sara