0

lol yea i have uncommented it, still no luck. Thanks, i do appreciate the help

Ok, well repost your code because there is something wrong still.

0

Ok, well repost your code because there is something wrong still.

Ok, here it is, i wasnt sure what quotes you were talking about putting in. Can you explain?

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <title>Remove Email</title>
  <link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
  <p>Please select the email addresses to delete from the email list and click Remove.</p>
  <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> 

<?php
	  $dbc = mysqli_connect('ipaddress', 'username', 'password', 'example')
    or die(mysql_error()); 
	
  // Delete the customer rows (only if the form has been submitted)
  
  
      if (isset($_POST['submit'])) {
		foreach ($_POST['todelete'] as $delete_id) {
        $query = "DELETE FROM email_list WHERE email = $delete_id";
		echo $query;
        mysqli_query($dbc, $query)
        or die(mysql_error());
        }
       
        echo 'Customer(s) removed.<br />';
		
      }




  // Display the customer rows with checkboxes for deleting
  $query = "SELECT * FROM email_list";
  $result = mysqli_query($dbc, $query);
  while ($row = mysqli_fetch_array($result)) {
    echo '<input type="checkbox" value="' . $row['email'] . '" name="todelete[]" />';


  echo $row['first_name'] ;
   echo  $row['last_name'] ;
  echo ' ' . $row['email'] ;
    echo '<br />';
  }

  mysqli_close($dbc);
?>

    <input type="submit" name="submit" value="Remove" />
  </form>
</body>
</html>
0
"DELETE FROM email_list WHERE email = '$delete_id'";

Quotes

That did it! you are my hero haha

I really do appreciate the help...means a lot

I will mark as solved

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.