multi row update

ruckus

People i've searched

I have a page with:

name 1
name 2
name 3

update(button)

When I click on update:
I want the scipt on the other side to update all three rows whith one query.

Any help?

LordShryku

How very vague of you....

What are you updating to? Why are you against looping? Is there something similar between all of these rows that can be used in your where statement?

ruckus

To mysql --> linux

Not realy,
How would I do that loop? I have about 30 fields on one page that need updating to there own rows.

<!-- Is there something similar between all of these rows that can be used in your where statement? -.>

Nope!

Thanks anyway

ruckus

help!!

LordShryku

Originally posted by ruckus
Dude are you a blank page or should i try to figure this out myself?

You think maybe I have other things going on as well?

You want instant gratification? You can't do this in one query.

ruckus

Would be cool though, not,

I have to also read many lines from my database and echo them, what a drag.

Its a vocab table, to edit the text on my GUI.

LordShryku

Ah, yes, you're right. Good luck with your updates from mysql to linux :rolleyes:

ruckus

you got me!

Linux --> Mysql

freebie

you need to dynamically name your text boxes using the ID value from the database as part of the input boxes name, so the input boxes might be named things like

3_FirstName
3_LastName
3_Title

4_FirstName
4_LastName
4_Title

etc etc

-- Also, create a hidden form input that contains all the ID fields in a list (ie, dynamically using PHP)
<input type='hidden' name='IDList' value="3, 4">

Then on the processing page, split the ID list into an array, then loop through that array and use the value to determine which fields to use as the data to update for each row (thus each loop through the array updates an entry in the database).

This should be enough to get you started. The rest is up to you.

HTH

ruckus

Thanks