Member Avatar for ShawnCplus

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.

Member Avatar for Plyswthsqurles

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>
Member Avatar for ShawnCplus 
"DELETE FROM email_list WHERE email = '$delete_id'";

Quotes

Member Avatar for Plyswthsqurles 
"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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.