[Resolved] Deleting Records (Multiple checkboxes)

qt4u

How would i go about Deleting Records (Multiple checkboxes) in dreamweaver MX i have a basic layout but lacking the code knowledge, would someone be able to solve this one for me? 😕 the code for the page has been pasted below.....

<?php require_once('Connections/vt.php'); ?>
<?php
mysql_select_db($database_vt, $vt);
$query_Delete = "SELECT * FROM vehicles ORDER BY Make ASC";
$Delete = mysql_query($query_Delete, $vt) or die(mysql_error());
$row_Delete = mysql_fetch_assoc($Delete);
$totalRows_Delete = mysql_num_rows($Delete);
?>
<html>
<head>
<title>Doc Title</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<form name="Delete" method="get" action="rem.php">
  <table width="483" height="200" border="0" align="center">
    <!--DWLayoutTable-->
    <tr> 
      <td width="477" height="196" valign="top"><table width="217" border="0" align="center">
          <!--DWLayoutTable-->
          <tr> 
            <td width="7%"><font color="#FF0000">Stock</font></td>
            <td width="7%"><font color="#FF0000">Make</font></td>
            <td width="7%"><font color="#FF0000">Model</font></td>
            <td width="3%"><font color="#FF0000">Year</font></td>
            <td width="76%"><font color="#00CC33"><strong>Delete?</strong></font></td>
          </tr>
          <tr> 
            <td><?php echo $row_Delete['Stock']; ?></td>
            <td><?php echo $row_Delete['Make']; ?></td>
            <td><?php echo $row_Delete['Model']; ?></td>
            <td><?php echo $row_Delete['Year']; ?></td>
            <td><div align="center"> 
                <input name="del[]" type="checkbox" id="del[]" value="<?=$counter?>">
                <br>
              </div></td>
          </tr>
          <?php } while ($row_Delete = mysql_fetch_assoc($Delete)); ?>
        </table>
        <table width="100%" border="0">
          <tr> 
            <td> <div align="right">Total Records <?php echo $totalRows_Delete ?> </div></td>
          </tr>
          <tr> 
            <td> <div align="center"> 
                <input name="rem" type="submit" id="rem" value="Delete Selected">
              </div></td>
          </tr>
        </table>

  </td>
</tr>
  </table>
</form>
</body>
</html>
<?php
mysql_free_result($Delete);
?>

svnfightsvn

where did $counter come from?
you need to output the row id as the checkbox value. When the user submits, you can then loop through each del[] and delete from the database where row id = del[]

ex.

foreach ($del[] as $value){
$query = "Delete from table where id = $value;
}

of course, this is very simplified...