Multiple update

[zzz]

I have a list of products as an output from a db table.

foreach ( $items as $r )
{
   echo "<input type=text name=var1>&nbsp;".$r->itemName."<input type=hidden name=itemID><br>";
}

I would like to update a value var1 for each product.

For one product I would just do:

query("UPDATE t1 SET value1='".$_POST['var1']."' WHERE id='".$_POST['itemID']."' LIMIT 1");

Not sure how can I do it all at once if I enter values for say 50 products...

[bpat1434]

UPDATE table SET (column1, column2, column3) VALUES
(newval1, newval2, newval3),
(newval4, newval5, newval6),
(newval7, newval8, newval9),
..... etc .....
WHERE.....

[zzz]

Thanks, but this doesn't look like a dynamic solution... or is it? What if I only enter values for 30 items out of 50?...

[devinemke]

your code seems to imply that $items is a 2-dimensional array. if so then basic idea would be:

foreach ($items as $value)
{
	echo '<input type="text" name="vars[' . $value['itemID'] . ']" value="' . $value['itemName'] . '"><br>';
}

and then in your form processing code:

foreach ($_POST['vars'] as $key => $value)
{
	$sql = "UPDATE t1 SET value1 = '" . $value . "' WHERE id = '" . $key . "'";
}

[zzz]

I am trying to exclude rows from a query by

WHERE var1 NOT LIKE '%parameter%'

but keep getting errors. Am I dreaming this NOT LIKE up? ...

[zzz]

Got it... fat fingers syndrom...