How to do multiple inserts into database from one form

[cbish]

I have a database of messages to sent and I would like to be able to populate it with multiple records from one form.

e.g. the table consists of , text and acnt. is the number of the person I want to send an messaeg to and acnt is which account to use for sending it.

If I want to send the same text to 100 people I don't want to have to add the number, text, acnt for each one. I would like to able to type the text, select the acnt and then enter a list of numbers to send it to (perhaps each one seperated by a ; or , ? Then, on submit, I would like the php script to read the list of numbers and write an individual record in the database (mysql) for each number with the same text and acnt.

How could I acheive this?

thanks in advance

[jc94062]

Say the list is in a text field called "list", run explode on this once you hit submit to get all the different numbers, then just run mail on the array...

foreach ($list_ar as $var)
{
     $query = myql_query("insert into table (text, accnt, list) values ('$text', '$accnt', '$var')");
}

something like that should do it.