update database

[nagasea]

DATABASE :

TITLE ITEM#
Book 50
Table 25
Pencil 20
Eraser 10
... ...
... ...
... ...

And I want to be able to list all the database in webform so I can edit the item number with only 1 submit button.

Something like

Book 50 Edit to:
Table 25 Edit to:
Pencil 20 Edit to:
Eraser 10 Edit to:

SUBMIT

Please keep in mind that I will keep adding the item title.
I think i need to use array for this task, can someone tell me how to do it right

[olaf]

Hallo,
first place a hiddenfield in your repeat region and put your update statement in a loop.

[nagasea]

can you give me more information about your way to handle this problem.

thanks

[olaf]

Sorry what you ask is described in a whole chapter of a beginning PHP book.
Do you know "for loops" or "do/while loops" ?

Maybe its easier to post the actual code and i comment you some changes.