multiple updates/deletes

Anon

hi, i'm trying to get a site to be able to do multiple deletes, with a confirmation, so what i have is a mysql database pulling out all the items, then each item has a check box next to it, you check all the items you want to delete, then hit confirm and it updates the results field sold, to Yes from No, the header takes it to a page which pulls out all the items where sold = yes. and then you can delete. the problem i'm having is that my update code only updates one item and not multiple, does anyone know how to do multiple deletes or updates? my code is:

$db = mysql_connect ("localhost", "root", "orange");
mysql_select_db ("carsuperstore", $db);

$sql = "UPDATE cars SET sold=\"Yes\" WHERE StockNO='$StockNO' AND '$delete'=\"Yes\"";
$res = mysql_query ($query, $db);

$res=mysql_query($sql);

mysql_close ($db);

header ("Location: multi_delete_confirm_list.php")
?>

thanks for your help, Martin

Anon

What you should do is name all your generated checkbox fields like StockNO[] but with difetent values.

Then on the receiving page you should have an array called StockNO which you can navigate with:

for($i=0; $i<count($StockNO);$i++)
{
// update code
$sql = "UPDATE cars SET sold=\"Yes\" WHERE StockNO='$StockNO[$i]' AND '$delete'=\"Yes\"";
$res = mysql_query ($query, $db);
}

Guillermo

Anon

Do you know what the code is for generating individual names for each checkbox, i'm not that great with php so any help would be great, thanks again, Martin

guillermo

First you should do a query were you get the id's of the rows you want to work with:

$sql = "select StockNO, SomeThingElse from cars";
$res = mysql_query ($query, $db);

while($row=mysql_fetch_array($res))
{
echo "<input type='checkbox' name='StockNO[]' value='".$row[StockNO]."'><br>";
}

All this inside a form. When you check on one, or more checkboxes and do a submit then the array $StockNO will be available on the receiving page.

Guillermo

Anon

hi there, i have a similar question although it seems to work although it does not update!

code to "activate" users
<form action="approve_new.php" method="post">
<?php
$sqlquery = "SELECT * FROM users WHERE active='0'";
$result = mysql_query($sqlquery,$connection);
$number = mysql_numrows($result);

$i = 0;

if ($number < 1) {
print "<tr><td colspan=\"8\">There are no new users to approve!</td></tr>";
}
else {
while ($number > $i) {
$thisName = mysql_result($result,$i,"first_name");
$thisLast = mysql_result($result,$i,"second_name");
$thisUser = mysql_result($result,$i,"user_name");
$thisEmail = mysql_result($result,$i,"email");
$thisActive = mysql_result($result,$i,"active");
$thisAdmin = mysql_result($result,$i,"admin");
$thisID = mysql_result($result,$i,"ID");

print "
<TR>
<TD>$thisName</TD>
<TD>$thisLast</TD>
<TD>$thisUser</TD>
<td>$thisEmail</td>
<td><input type=\"checkbox\" name=\"check[]\" value=\"$thisID\"></td>
<td>$thisAdmin</td>
<td>$thisID</td>
</TR>";
$i++;
}
}

and now approve_new.php
$sql="UPDATE users SET active='1' WHERE ID='$value'";
if (sizeof($check)< "1") {
echo "Please Select a someone to approve!";
exit;
}
foreach ($check as $value) {
mysql_query($sql,$connection);

}

it all goes through OK - no error messages but it will not update the database...
thanks!
mamu

Anon

EEK!

Weird problem here:
This script works, kinda..
it only updates the first record with a checkbox unless I check ALL of the ones above each other.
(so if I check only the second box, it won't work, and I echoed to see what it was doing and it is only getting the first record.)
However, if I check both the first AND second record, it works fine..
and the first one by itself works fine..

Any help woudl be appreciated..
(oh yeah, and I have to REFRESH the page at each time as well.)

here is 'test'php'

echo "<form method='post' name='test[]' action='test.php'>";

$db = mysql_connect ("localhost", "user", "password");
mysql_select_db ("database", $db);

$sql9 = "select empnumber, SEC_LVL from employees ";
$res = mysql_query($sql9);
echo "<table border = '1'>";
echo "<TR><TD>Check</TD><TD>SEC_LVL</TD><TD>Empnumber</TD></TR><TR>";
while($row=mysql_fetch_array($res))
{
echo "<TD><input type='checkbox' name='SEC_LVLC[]'></TD>";
echo "<TD><input type='text' name='SEC_LVL[]' value='".$row[SEC_LVL]."'></TD>";
echo "<TD>".$row[empnumber]."</TD><input type='hidden' name='empnumber[]' value='".$row[empnumber]."'></TR>";
}
echo "</table>";

for($i=0; $i<count($SEC_LVLC); $i++){
$query = "UPDATE employees SET SEC_LVL='".$SEC_LVL[$i]."' WHERE empnumber='".$empnumber[$i]."' ";
$res = mysql_query ($query) or die("Couldn't upddate database.<BR>empnumber=".$empnumber[$i]."<BR>SEC_LVL=".$SEC_LVL[$i]."<BR>");

echo "Empnumber=".$empnumber[$i]."<BR>";
echo "SEC_LVL=".$SEC_LVL[$i]."<BR>";
echo "SEC_LVLC=".$SEC_LVLC[$i]."<BR>";
echo "<hr>";
$tmp = "<meta http-equiv=\"refresh\" content=\"0; URL=test.php\">";
echo $tmp;
//exit();
}

mysql_close ($db);

this code may be useful to others as well..
(but you might want to wait until I get it fixed first though..hehe.. Will post here when it's done..)

Thanx,
Matt