Delete All Rows with Check Box

[unemployment]

Can I use php to delete multiple rows that have a checkbox selected. I'm not sure how to go about doing this.  Any  suggestions? 

[msaz87]

Do something like this:

 

<?php while($row = mysql_fetch_arrary($myQuery)) { ?>

<?php echo $row['title'];?> 

<input type="checkbox" name="delete_me[$row['ID']]">

<?php } ?>

 

Then after the form is posted...

 

$delete_me = $_REQUEST['delete_me'];

if(!empty($delete_me)) {

foreach($delete_me as $key => $value){

if($value == "on") {

mysql_query("DELETE * FROM yourTable WHERE ID = '$key'") or die(mysql_error())

}

}

}

[unemployment]

Do something like this:

 

<?php while($row = mysql_fetch_arrary($myQuery)) { ?>

<?php echo $row['title'];?> 

<input type="checkbox" name="delete_me[$row['ID']]">

<?php } ?>

 

Then after the form is posted...

 

$delete_me = $_REQUEST['delete_me'];

if(!empty($delete_me)) {

foreach($delete_me as $key => $value){

if($value == "on") {

mysql_query("DELETE * FROM yourTable WHERE ID = '$key'") or die(mysql_error())

}

}

}

 

That didn't seem to work for me

[msaz87]

Post some code

[mikosiko]

That didn't seem to work for me

 

"seems" doesn't help much to the people here that is trying to help you.

 

- what exactly are you getting? 

- which is the complete code that you are using?