PHP My Admin snippet for bounce handling

Solutions for other advanced phplisters

PHP My Admin snippet for bounce handling

Postby Mike_R » 9:46am, Wed 18 Jul, 2007

Having imported emails from our customer database (some of which were gathered 5 years ago) into PHP List, when my first message went out we ended up with a large quantity of bounces due to invalid emails. So I wrote the below SQL to extract user id, email and foreign key (for cross-referencing with our external DB).

Code: Select all
SELECT mb.user, uu.email, uu.foreignkey
FROM phplist_user_message_bounce AS mb, phplist_user_user AS uu
WHERE mb.message = '5'
AND mb.user = uu.id


If you want to use this on your own system you may want to remove the

Code: Select all
mb.message = '5' AND


as 5 is the message ID of the mailing that I was interested in.
Mike_R
PL Geek
 
Posts: 88
Joined: 10:34am, Wed 30 May, 2007

Return to Advanced Answers, Howtos, Tips & Tricks

Who is online

Users browsing this forum: No registered users and 1 guest

cron