Delete multipe records in 1 form

[netfrugal]

I have been reading alot on how people update/delete multiple records with one form. So far I am getting confused, which is my own fault, but my limited knowledge on arrays keeps me misunderstanding people's techniques.

Below is a form with 2 columns: recID, and checkboxes.

Simply, I wish to see the entire list from mysql and when I click the checkboxes next to the recID, then click 'submit' - those will obviously need to be deleted.

But, the question is How?? What is the execution script supposed to look like? And, is there more to the form? I just don't know, so any help, with simple explainations will be very much appreciated!

Form:

<form id="form1" name="form1" method="post" action="execution.php">

<table width="100%" border="0" cellpadding="5" cellspacing="2">
<tr>
<td class="nicetableheader">Record ID</td>
<td class="nicetableheader">Delete</td>
</tr>

<? while ($row = mysql_fetch_array/COLOR) { ?>

          [COLOR=Green]<tr>
		<td>[COLOR=Red]<?php[/COLOR] [COLOR=Blue]echo[/COLOR] $row['[COLOR=DarkRed]recID[/COLOR]'];[COLOR=Red]?>[/COLOR] </td>
		<td>[COLOR=DarkOrange]<input name="recID" type="checkbox" id="recID" value="[COLOR=Red]<?php[/COLOR] [COLOR=Blue]echo[/COLOR] [COLOR=DarkGreen]$row[[/COLOR]'[COLOR=DarkRed]recID[/COLOR]'[COLOR=DarkGreen]];[/COLOR][COLOR=Red]?>[/COLOR] "/>[/COLOR]</td>
          </tr>[/COLOR]

<? } ?>

<tr>
<td align="right" colspan="6"><input type="submit" name="Submit" value="Delete"/></td>
</tr>
</table>

</form>

[rajug]

Make your checkbox as array like this:

<? while ($row = mysql_fetch_array($sql)) { ?>

<tr>
<td><?php echo $row['recID'];?> </td>
<td><input name="recID[]" type="checkbox" id="recID[]" value="<?php echo $row['recID'];?> "/></td>
</tr>

And you can track from your record deleting action script do like this:

	$ids = $_POST['recID'];
	if(count($rds) >= 1){
		for($i = 0; $i < count($ids); $i++){
			$sql = "delete from tablename where recID=" . $ids[$i];
			mysql_query($sql);
		}
	}

Please let me know whether it does works for you or not?

[Weedpacket]

You could also use $id_string=join(',', $ids), then "delete from tablename where recID in ($id_string)"; no need for a loop.

As ever, all these IDs should be checked to see that they are valid (and that code assumes for example that they are numeric) and all the other usual prophylactic measures that have to be taken with any user input.