2 Foreach statements update a mysql row

[tsm1248]

I have a checkbox when it is checked i garb its value ---meaning the id

i take that id and i would like to use it in my where mysql_query statement

 

then I would like to insert the array from the other foreach one after another with

a prov meaning provider

 

here is my code

 

print "<select name='prov[]'>";
print '<option value=""></option>';

mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("db1") or die(mysql_error());
$query2 = "SELECT * FROM admin";
$result2 = mysql_query($query2) or die(mysql_error());
while($row2 = mysql_fetch_array($result2))
{
if ($row2['priv']==prov){print '<option value="'.$row2['user'].'">'.$row2['user'].'</option>';}
}

print '</select>';


print '</div>';

 

<?php

if (!empty($_POST[submitdeletetic]))

{

foreach ($_POST["delete"] as $key => $id)	
foreach ($_POST["prov"] as $prov)
{
mysql_query("UPDATE tickets SET prov='$prov' WHERE id='".(int)$id."'") or die(mysql_error());

}
}
?>