Multiple Question Updates

kbc1

I have a form which displays anything upto 30 sentences (strings) which i retrieve from a database depending on the ID which is passed to the query, and each sentence is displayed within a text box on my web page in a while loop:

<textarea name=\"sentencetext\" id=\"sentencetext\" cols=\"1\" rows=\"1\">$sentencetext</textarea>

I need to be able to allow the user to simply make a change to any or all textareas and then click a save button. This then needs to run an update query which updates the database accordingly for each text area.

Could anyone give any simple examples on how this would be done?
Thanks in advance
K

devinemke

are all of these sentences stored in a single field or multiple fields?

kbc1

Each sentence is in it's own field with it's own ID. This is the way i need to maintain the database. What would be the best way to update them?

devinemke

kbc1 wrote:
Each sentence is in it's own field with it's own ID

that is not very clear. are they all in separate fields within each row or are they in a single field in multiple rows? in other words does your data structure look like this:

id = 1 | sentence1 = this is a sentence | sentence2 = this is another sentence | sentence3 = this is yet another sentence
id = 2 | sentence1 = this is a sentence | sentence2 = this is another sentence | sentence3 = this is yet another sentence
id = 3 | sentence1 = this is a sentence | sentence2 = this is another sentence | sentence3 = this is yet another sentence

or this:

id = 1 | sentence = this is a sentence
id = 2 | sentence = this is a sentence
id = 3 | sentence = this is a sentence