submitting form to mulitple database ent

[Anon]

I have a table which is constructed from several rows in a mySQL database. eg:

id=1 name age text1 text2
id=2 name age text1 text2
id=3 name age text1 text2

I would like to make this table consist of a form/fields so i can update multiple rows from one submit button, rather than having to submit each individual row after a change is made.

How can this be done?

I know a do while loop would work through the rows but how can the rows be individual and the information submitted to the relevent row if the form fields are named the same?

Being a newbie to this it's causing a few head aches (c:

[Anon]

Your form fields will be named as an array:

<input type="text" name="age[]" />

And so you have a couple of them:

<input type="text" name="age[]" />
<input type="text" name="age[]" />
<input type="text" name="age[]" />
<input type="text" name="age[]" />

So when the user submits the form, you'll have an array age[] and just use a while loop (or a for loop) to read each entry in the array and pass it to MySQL.

Diego