Jump to content

2 Foreach statements update a mysql row


tsm1248

Recommended Posts

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());

}
}
?>

Link to comment
https://forums.phpfreaks.com/topic/221422-2-foreach-statements-update-a-mysql-row/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.