add multiple records at one time

[niekb]

I have a MySql db with 4 collums (Jobs, Customers, Clients, Relations)
When i want to add a person to a jobapplication i have a pulldownmenu with
all the available persons at that moment.
( Stored in the Persons db) I can select one, submit the query, and the record is added to the relationsdb. If i want to select 2 persons i have to return to this page and add a new one.

This is what i want:
I want to show all persons that are available, this is no problem, instead of the pulldownmenu ill putt them in a row. I can do that, but for each person there must be a selectbox, so each row a a selectbox.

You can select muliple persons and when i submit the query, it must add for each
selected person a new record into the relations db. (post mulitple records at
one time)

The thing i can\'t figure out is how to put a selectbox for each record and
how to add for each selected person a new record into the relations db.

So if you understand my problem i hope that someone can help me.....

Thanks in advance..
Niek

[anikin]

You can still use the pull down menu, but with the MULTIPLE property. There you can select more that one person.

If so, name the select as names[] or anyother name but place always the [] in the end to get the result in an array.

Afterwards just as you do for one guy do :

while (list(,$value)=each($name)){
//whatever you do for one but this time the code is $value
}