Help: Delete Rows From Database Via Checkboxes

[bradleydh]

Here is what I have so far:

<?php
require_once("../config.php");
mysql_connect("$database_server","$database_username","$database_password");
mysql_select_db("$database_name");
$sql = "SELECT * FROM ".$database_prefix."_subscribe";
$result = mysql_query($sql);
echo("<div align=\"center\">
<center>
<form method=\"post\">
<table border=\"0\" cellpadding=\"2\" cellspacing=\"0\" width=\"50%\">
<tr>
<td bgcolor=\"#000000\">
<p align=\"center\"><b><font color=\"#FFFFFF\" size=\"2\" face=\"Verdana\">Delete</font></b></td>
<td bgcolor=\"#000000\"><b><font color=\"#FFFFFF\" size=\"2\" face=\"Verdana\">Name</font></b></td>
<td bgcolor=\"#000000\"><b><font color=\"#FFFFFF\" size=\"2\" face=\"Verdana\">Email Address</font></b></td>
</tr>");
While ($row = mysql_fetch_array($result)) {
$id = $row['ID'];
$email = $row['Email'];
$name = $row['Name'];
echo("<tr>
<td bgcolor=\"#E6E6E6\">
<p align=\"center\"><font size=\"1\" face=\"Verdana\"><input type=\"checkbox\" name=\"delete\" value=\"".$id."\"></font></td>
<td bgcolor=\"#E6E6E6\"><font size=\"1\" face=\"Verdana\">".$name."</font></td>
<td bgcolor=\"#E6E6E6\"><font size=\"1\" face=\"Verdana\">".$email."</font></td>
</tr>");
}
echo("</table>
<br>
<input type=\"submit\" value=\"Delete\" name=\"delete\">
</form>
</center>
</div>");
mysql_close();
?>

So far, it basically just shows the database HMTL... What will I have to do to make this functional?

...I would like the script to works something like
If Post = delete
delete it
else
display users

Any help would be greatly appreciated.

[bradleydh]

Any help?

Here is the updated code:

<?
require_once("../config.php");
mysql_connect("$database_server","$database_username","$database_password");
$entry_limit = "25";
$sql="SELECT COUNT(*) AS total FROM ".$database_prefix."_subscribe";
$sql_result=mysql_db_query($database_name, $sql);
$sql_result_array=mysql_fetch_array($sql_result);
$total=$sql_result_array['total'];
$sql="SELECT * FROM ".$database_prefix."_subscribe";
echo("<div align=\"center\">
<center>
<form method=\"post\">
<table border=\"0\" cellpadding=\"2\" cellspacing=\"0\" width=\"50%\">
<tr>
<td bgcolor=\"#000000\">
<p align=\"center\"><b><font color=\"#FFFFFF\" size=\"2\" face=\"Verdana\">Delete</font></b></td>
<td bgcolor=\"#000000\"><b><font color=\"#FFFFFF\" size=\"2\" face=\"Verdana\">Name</font></b></td>
<td bgcolor=\"#000000\"><b><font color=\"#FFFFFF\" size=\"2\" face=\"Verdana\">Email Address</font></b></td>
</tr>");
if (empty($_GET['start']))
   {
   $start=0;
   $sql.=" LIMIT $start, $entry_limit";
   }else
   {
   $start=$_GET['start'];
   $sql.=" LIMIT $start, $entry_limit";
   }
$sql_result=mysql_db_query($database_name, $sql);
$sql_rows=mysql_num_rows($sql_result);
$color1 = "#FFFFFF";
$color2 = "#E5E5E5";
$row_count = 0;
for ($a=0; $a < $sql_rows; $a++)
    {
    $sql_array=mysql_fetch_array($sql_result);
    $id=$sql_array['ID'];
    $email=$sql_array['Email'];
    $name=$sql_array['Name'];
    $row_color = ($row_count % 2) ? $color1 : $color2;
    echo "<tr>
    <td bgcolor=\"".$row_color."\">
    <p align=\"center\"><font size=\"1\" face=\"Verdana\"><input type=\"checkbox\" name=\"del[]\" value=\"".$id."\"></font></td>
    <td bgcolor=\"".$row_color."\"><font size=\"1\" face=\"Verdana\">".$name."</font></td>
    <td bgcolor=\"".$row_color."\"><font size=\"1\" face=\"Verdana\">".$email."</font></td>
    </tr>";
    $row_count++;
    }
    echo "<tr><td colspan=\"3\"><p align=\"right\"><font face=\"Verdana\" size=\"1\">";
if ($total>0)
   {
   if ($start<$total && $start>0)
      {
      $Res1=$start-$entry_limit;
      echo "<A HREF=\"".$PHP_Self."?start=$Res1\"><< Previous</A> ";
      }
   $pages=$total / $entry_limit;
   if ($pages>1)
      {
      for ($b=0,$c=1; $b < $pages; $b++,$c++)
          {
          $Res1=$entry_limit * $b;
          echo "[ <A HREF=\"".$PHP_Self."?start=$Res1\">$c</A> ] \n";
          }
      }
   if ($start>=0 && $start<$total)
      {
      $Res1=$start+$entry_limit;
      if ($Res1<$total)
         {
         echo " <A HREF=\"".$PHP_Self."?start=$Res1\">Next >></A>";
         }
      }
   }
   echo("</font></p></td></tr></table>
   <input type=\"submit\" value=\"Delete\" name=\"delete\">
   </form>
   </center>
   </div>");
mysql_close();
?>