I have a form, where someone enters emails into a text area, each email is on a separate line.

Could anyone tell me how I would loop through these setting these fields aswell:


These must be entered into a table called emails.
I'm just having trouble getting it to get a separate entry on every line and looping it to insert it into the database.

Also wondering, instead of using hundreds of queries for this one, is it possible to only use 1 query that inserts them all?

Thank you