It's late and I'm getting groggy.
I have a table called mail_list. There are four possible list_names.
I want to be able to either delete an email associated with a particular
list or all matching email.
Deleting WHERE email AND list match works fine. The problem is when I want
to delete an address from all of the lists.
First I check the database to see how many matches I have.
$check_sql = "
SELECT list_id, email FROM mail_list
WHERE email = '$this_email'
For purposes of discussion, we'll say the answer was 3.
I use this sql when I want to delete all of the email addresses:
$remove_sql = "
DELETE FROM mail_list
Only the first record is deleted even though the check_sql found more than
Why doesn't the delete get all of the email addresses that match the first
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php