Mail() to muptiple addresses from my database?

[matthewst]

I'm using mysql and php4. In my database I have an email address column. Some of my users want forms emailed to multiple address. The easiest way to accomplish this is to list multiple addresses for those users. My question is this: How do I "structure" the data in my email address column so php will pick it up and send.

example(in the database): [e-mail]
php picks this address up and sends the email

example 2(in the database): [e-mail], [e-mail]
no good

example 3(in the database): [e-mail]; [e-mail]
no good

I've tried various combinations of quote, double quote, and escape charectors. I can't seem to find the right one. Any ideas?

[tave]

Create a table to hold the email adresses, email id, and user id (The user id is a foreign key from your users tables) Then you can use the user's id to find all of their email addresses during a query.