textarea \n = new record

[tgavin]

I would like to enter email addresses into an text area, each address seperated by a new line. Then , each address will become it's own record.

so, if I enter into the text area
email01@foo.com
email02@foo.com

in the db each email address has it's own record
id = 1, email = email01@foo.com
id = 2, email = email02@foo.com

What's the best way to do this?
Thanks!

[Mike]

$emails = split("\n", $userinput);
foreach($emails as $email)
{
 // insert
} 

Would work.

[Dean C]

Something like:

$emails = preg_split('/[\r\n]+/', $_POST['emails']);
foreach($emails AS $email)
{
    mysql_query("INSERT INTO table (somefield) VALUES ('" . mysql_real_escape_string($email) . "')");
} 

[tgavin]

Thanks guys, that was perfect!