[RESOLVED] Updating multiple rows

[OniLink]

Hi,

What is the best way to update multiple rows where the WHERE clause is determine by a variable.

Here is the pseudocode for what I want to do:

for (i=0; i<numItems; i++) {
// "UPDATE product_list SET product_sold = product_sold+1 WHERE $_POST['i'+i]";
}

Thanks for any help,
~Oni.

[nemonoman]

That's pretty much what you do...just loop through, updating a row at a time.

You could also set up the loop to create an IN statement
"UPDATE product_list SET product_sold = product_sold+1 WHERE SomeIdentifier IN ('11','22','33')";

which would update the rows where SomeIdentifier was 11 or 22 or 33.

[OniLink]

Thanks heaps for your help. I thought using a for loop would jam it somehow... guess I was wrong 🙂