PHP - MYSQL - Help PLEASE!

[Guest]

I need to update records in a database when the users clicks submit.  For instance, I have a recordset returning from 1 to 100 rows.  When the user clicks submit, I need to update each row the original recordset has returned.  I have 3 fields in each row that need to be updated when it's submitted.  How can I accomplish it with ONE click??

[Guest]

Accomplish it with one click by using a script. More details from you on your end = more details provided to you on our end whereas vague description = vague answer.

[Guest]

recordset returns 1 to 100 rows.

Field in those row(s) I need to update are purchased, purchase_date and purchaser_id

If the recordset returns 10 rows, I need to update the 3 fields above in all 10 rows.

Thanks.