Delete Selected Record

[Dysan]

How do I delete a record, upon the user clicking the check box displayed next to each record, and a delete button being clicked?

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
  die(mysql_error());
}

mysql_select_db("db", $con);

$result = mysql_query("SELECT * FROM person");

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

mysql_close($con);
?>

[rsmith]

Well each person from your database should have a unique ID assigned to it. what you need to do is set the value of the checkbox to be the id of the current record being outputted. However, in your case it looks like you're trying to create a series of checkboxes that are part of an array. If that's the case you need to put

echo "<input type='checkbox' name='checkbox[]' value='".$row['id']."'>";

You also need to create a form with a submit button that will pass the checked boxes to a script that will process the delete. You'll have to iterate through your checkbox[] array and delete each checkbox individually.

I hope that helps.