Update multiple records from one table on one form

[hazi]

I would like to take the recordset from a table and populate a form that will enable a user to update each of the fields from the recordsets, I would then like the user to only have to POST the form once, and then each of the entries on the form update the relevant recordset from the original table. Making updates more efficient.

This is easy with ASP and Ultradev, but I can't get my head round it with PHP and MySQL.

Any help would gratefully be appreciated. Thanks in advance.

[ehlpdesk]

Hello,

You could use the UPDATE query to make changes with
one form.

$query = "UPDATE tablename SET name='$name', lastname='$lastname' WHERE userid='$userid'";

mysql_query($query);

Hope this helps.

Regards,
Ray

[hazi]

Thanks for the prompt reply, but I understand the UPDATE SQL command, what I wanted to know was there any way to have one form populated with all the rows from a table, and then allow changes to be made and the user just required to press SUBMIT once, which would then take each record from form and update corresponding record in the recordset?