um... help UPDATE a value in multiple rows

[glennn.php]

not sure how to describe this...

 

having multiple rows of items, prices, i want to build a single form with which my client can change a number of prices where there would be a column of part nos along with their respective price fields, populated, so that he can change any number of them.

 

i can get the values from the db and print them out into such a form, but i don't know exactly how to build the UPDATE query...

 

does that make sense?

 

thanks for your help.

 

gn

[timvdalen]

Create an array of rowid's that need to be edited

 

foreach($needtobeedited as $id){

UPDATE `table`(`col1`,`col2`,`col3`) VALUES('1','2','3') WHERE `id`='$id'

}

 

Or, if it's a fixed numer:

 

UPDATE `table`(`col1`,`col2`,`col3`) VALUES('1','2','3') WHERE `id`='1' OR `id`='2' OR `id`='3'

[glennn.php]

thanks very much, easy plan...

[timvdalen]

No biggie.

Please mark this topic as solved, and for future reference, leaving the 'um... help' part out would make your title way better.

[glennn.php]

sometimes my fingers type what i'm um... thinking. ) - i'll remember that next time. sorry