Multiple ADD/UPDATE at one time

Anon

Hey guys. I'm looking to ADD multiple records at one time. For example, I want a form that lists all of the employees, and then a blank textbox where I can add all of their phone numbers at once. Instead of having to click on each person, add the phone number, then click save. I want to be able to enter in all the numbers at once and click the save button once. I would suppose an array of some type.

I know this doesn't sound logical because there could be an error and would be hard for the user to debug. The above isn't the info I really need. The user will only be entering in one number, or probably even a combo box. I just need to know how I could send the array into an ADD or UPDATE mysql statement. Thanks!

mmilano

i think this is what you are trying to do, but maybe not

if the textbox is like an html textarea, then the numbers would be added like this in the same textarea named "numbers":
800-555-1212
800-555-2323
800-555-3434

each number can be seperated by a new line.. then before you insert the numbers in the database, split them into an array:

$array=split("\n",$numbers);

now you will have each number in a seperate variable named "$array[]" and you can insert them as you normally do into your db.

hope this helps
-mike

Anon

Ehhhhh...kinda what I need. I'm looking to have a seperate textbox next to each employee ID so I can put in their phone number. Kind of like this (I hope spacing isn't messed up):

EMPLOYEE ID1 ________ <-input phone1 there
EMPLOYEE ID2 ________ <-input phone2 there
...so on

I then want to be able to add (or update) all of them at once. Hope this helps. I don't really know if this can be done or not. I figure an array will do it. Thanks again!