Need Help Processing Arrays From Form

[jbh]

Hello, basically I am updating database records from a form, and each row (I have 10 at the moment) starts with a checkbox called package[]

And in each row, at the end, is a text field for the commission, called com[]

The point is to select a checkbox (row) and enter a commission value and then submit, thus, updating the commission field for that selected row

The problem is, I do not know how to process both variables in the response page so I can carry the newly modified com[] value with the package value (1-10, as in 10 rows, each having a unique id as in the database) and use both for the sql update statement

I can only save the package[] value, not com[]

What can I do?

Thanks

[BuzzLY]

I don't know if I completely understand you... but I would suggest using the unique id for the record in MySQL as part of the field names you are updating. So, your commission text field for record #42 in the database becomes com_42.

You can then iterate through your post variables, and create an array as follows:

$record[42][com] = $32

Does that send you down the right path?

[jbh]

Hello, thanks. Maybe it's best if I show a demo so it's easier to visualize:

This is actually an html randition, not the live version, but it is helpful to see how it's setup

http://www.makemyscript.com/testform.htm

If you select a row (record) your job is to change the value in the commission text field.

So, then, you would update the record in the db, through this form.

The problem is, I cannot cleanly find out how to select, let's say 4, rows (and the package variable is always the ID value in the database table) and update each row's commission field and then have them update the db.

Basically, I want the response page to somehow, cleanly loop all of the 4 selected responses and use that data (package value and commission value which I just entered) and use that to update the row in the mysql table

The problem is, it is not so easy for me to do this cleanly. Everything I attempt fails.

That's putting it simply.

[jbh]

Can you please explain how I can do what you suggested? Remember, if I knew how to, I wouldn't be here 😉

Thanks