Jump to content


Photo

pop3 import to mysql - multiple recipients


  • Please log in to reply
1 reply to this topic

#1 quasiman

quasiman
  • Members
  • PipPipPip
  • Advanced Member
  • 194 posts
  • LocationPortland, Oregon

Posted 26 July 2006 - 04:45 PM

This is more of an advice question than coding...

I have a catchall@domain.com email address importing into 2 tables (one for messages, another for attachments).  I can remove the domain.com part of an email to import only the user name, and then use that to only let users see emails associated to their name - IE: user login "Bill" can only see emails sent to bill@domain.com.
But if an email is sent to more than one person, it comes in as user@domain.com, user2@domain.com, user3@otherdomain.com.  So...what can I do about it?  I'm thinking I could explode the list and remove each of the domain.com's, then create a seperate record for each user at my domain, but how would I handle the address's not going to my domain?

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 26 July 2006 - 05:42 PM

It's up to you "how" to you want deal with off-domain e-mails.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users