deleting record from loop

[brockie99]

I am trying to delete a record from a table 'Categories', and am not sure how to approach the deletion. I have displayed the records in a table format and give the user the option to select the delete option from a select box and then once the submit (delete record) button is clicked, the record/s is deleted depending on which have been selected.
here is the code:

$select = mysql_query("SELECT * FROM category;",$db);
while ($myrow = mysql_fetch_array($select))
{
printf ("<tr><td>%s</td><td>%s</td><td><select><option value = ''><option value = 'Delete'>
Delete</select></td><td><select><option value = ''><option value = 'Modify'>Modify</select></td></tr>", $myrow["name"],
$myrow["description"], $myrow["ID"]);
}
?>
<form>
<tr><td></td><td></td><td><input type = "submit" name = "delete" value = "Delete"></td><td><a href = "modifyCategory.php">Modify</a></td></tr>
</form>
</table>
<hr>
<?php
if($delete)
{
$drop = "DELETE FROM category, WHERE ID = '$ID';";
$result = mysql_query($drop);
echo "Record Deleted!";
echo mysql_error();
}

Thanks

[The_Chancer]

There are a few things I would change about your code..

First - you have to close your tags...
<select name="name">
<option>text</option>
</select>

Then I would name each select box as the ID value(prefixed by S for select), and give the modify /amend as values in the options.

So, when the form is submitted,

foreach($_POST as $key=>$val)
{
    if (substr($key,0,1)=="S")
    {
         if ($val=="Delete")
         {
           $drop="DELETE FROM category WHERE ID='".substr($key,1)."'";
           $result=mysql_query($drop);
          }
      }
}

Something along those lines anyway...