PHP MySQL Update Records Loop

[jn148]

Newbie needing help...

I have a database with five fields:
ID
First
Last
Position
Address

I have a page that loops through a recordset to display each record in text fields on a form.

I have figured out how to update a single record in the database, but what I want to do now is to use the form that displays all the records in the database to update all the records at once.

I used to program ASP, but am totally new to PHP, and can't figure out how to get the loop to update all the records...

Any help would be greatly appreciated - just a newbie looking for a code snippet to help out!

[ratso]

make sure you list every string you send in you form in your sql query.

$sqlquery = "INSERT INTO $table
VALUES('$client_id', '$name', '$street')";