Update multiple rows

[Brusca]

I have learnt how to update a record in a database through a form element in HTML. But I am curious as to how I can update multiple records/rows in a database.

I have a form setup and displayed inside are 10 records on an html page. A textbox for each record displays what is called an "order_id" value.

Basically I want the user to be able to change any of the order_id values in the text boxes and then submit. This is all setup perfectly but I am not sure how to handle an update with multiple records.

Any clues??

[theeper]

I am assuming that if a user is going to be able to update multiple records in your table, there is some field with unique values to that user.

If your table has a user_id field or something, just issue a normal UPDATE query.

$sql = "UPDATE mytable SET order_id = '" . $POST['order_id'] . "' WHERE user_id = '" . $POST['user_id'] . "'";

This will update all the records with the user id that you passed.