Delete multiple rows from table

Hi,

I know how to delete one row from mysql table by using

<input type="radio" name="ID" value="'.$IDE.'" id="e" >
and
$delete = mysql_query("DELETE FROM `my_options` WHERE id = '$IDE'");

But now I need to delete multiple rows by one pushed button. Also, then I will need checkboxes to select multiple items...

But how to delete selected??

Thanks for your time.

But how to delete selected?? You could make a list of selected ids like
(1,2,3,4,5 ...) and use that list, like
"DELETE FROM `my_options` WHERE id IN (1,2,3,4,5)"

this list is an array or what?

no, it’s a string (like any value in a SQL string)

<form action="./" method="post">
<input type="checkbox" name="foo[]" value="1" />
<input type="checkbox" name="foo[]" value="2" />
<input type="checkbox" name="foo[]" value="3" />
<input type="checkbox" name="foo[]" value="4" />
<input type="checkbox" name="foo[]" value="5" />
<input type="submit" name="submit">
</form>
<?php
if(isset($_POST['submit'])){
if(isset($_POST['foo'])){
foreach( $_POST['foo'] as $checkBoxValue ) {
mysql_query("DELETE FROM `my_options` WHERE id = '" . $checkBoxValue . "'") or die ( mysql_error() );
}
}
}
?>

foreach( $_POST['foo'] as $checkBoxValue ) {
mysql_query("DELETE FROM `my_options` WHERE id = '" . $checkBoxValue . "'") or die ( mysql_error() );
}It's not a good practice to run query inside a loop, as it'll add overheads to the DB server.

foreach( $_POST['foo'] as $checkBoxValue ) {
$q = mysql_query("DELETE FROM `my_options` WHERE id = '" . $checkBoxValue . "'") or die ( mysql_error() );
mysql_free_result( $q );
}

<?php
$str = "(" . implode( ", ", $_POST['foo']) . ")";
$q = mysql_query("DELETE FROM `my_options` WHERE id IN " . $str ) or die ( mysql_error() );
mysql_free_result( $q );
?>

<?php
$str = "(" . implode( ", ", $_POST['foo']) . ")";
$q = mysql_query("DELETE FROM `my_options` WHERE id IN " . $str ) or die ( mysql_error() );
mysql_free_result( $q );
?>


you changed your script twice.... which is correct?

both are, technically

one is more resource efficient than the other as it doesn't make use of a query inside a loop, which as abduraooft stated, creates (unnecessary) overhead

thanks for answers :)

No sanitisation/validation of the id's has been done in those examples, however. Do the necessary checks.