Display All Records with Checkbox

[Dysan]

Hi.

I have the following code, that displays records in my database.
How do I display each record along with a checkbox, then when a delete button is clicked, delete the selected records?

mysql_select_db("my_db", $con);

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

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

[roscor]

<table width="800" border="0" cellspacing="0" cellpadding="0" align="centre" >
<tr>
<td width="463" align="center">
  </td>
  </tr>
  </table>


  <table width="800" border="0" cellspacing="0" cellpadding="0" align="centre" >
  <tr>
   <td width="169" align="left"><font face="Verdana" size="2" color="#000000">Check Box:</font></td>   

	<td width="206" align="left"><font face="Verdana" size="2" color="#000000">Firstname:</font></td>
	<td width="83" align="left"><font face="Verdana" size="2" color="#000000">Lastname:</font></td> 


</tr>

</table>





<table border="0" width="800" height="50"  bordercolor="#111111">


<tr>

  <td style="border-style:solid; border-width:1px; border-color:#000000;" width="100%" height="20" valign="top"  bgcolor="#FFFFFF" bordercolor="#111111">


<div class="scrollable" style="height:400px; width:800; overflow:auto;">


 <table cellSpacing="0" cellPadding="1" border="0" width="800" height="20" align="top"> 
<td  align="center"><font face="Verdana" size="2" color="#000000"></td>
<td  align="center"><font face="Verdana" size="2" color="#000000"></td>
<td  align="center"><font face="Verdana" size="2" color="#000000"></td>
</tr>



<?PHP
$color1 = '#EEEEEE';
$color2 = '#FFFFFFF';

mysql_select_db("my_db", $con);

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

$i = 0;

while ($row = mysql_fetch_array($result)) {

//create alternating row colour
$color = (($i%2 == 0 || $i == 0) ? $color1 : $color2);

$Last=$row['Firstname'];
$First=$row['Lastname'];


//Now target your form destination with action on that page, delete etc with form action
?>


<form action="Target page.php" method="post">
<font face="Verdana" size="2" color="#000000">
<th><input type="checkbox" name="Lastname[]" value="<?php echo $Last;?>" MULTIPLE> <? echo "<td bgcolor=$color align='center' size='100'><font face='Verdana' size='2' color='#000000'>$Last</td>"; ?>
<input type="hidden" name="Firstname[]" value="<?php echo $First;?>"><? echo "<td bgcolor=$color align='center' size='200'><font face='Verdana' size='2' color='#000000'>$First</td>"; ?></th>
</font>

</tr>

<?PHP
$i++;
}
}

echo "</table>";


?>
&nbsp;<input type="checkbox" name="checkall" onclick="checkUncheckAll(this);"/>select/unselect<br /><input type="submit" value ="send"></form>

try this, un-tested