Link to home
Start Free TrialLog in
Avatar of jaxbrian
jaxbrian

asked on

mulitple submissions t the same time import into mysql?

what I am trying to do is grab multiple email addresses at the same time from the same form. I want to have multiple fields for the email addresses.
my question is, is it possible to post the same variable to my query at the same time?
like if the DB on has one row called `email` how would I post multiple emails at the same time? i can do it one at a time.
is it clear what I am asking about?
ASKER CERTIFIED SOLUTION
Avatar of LAMASE
LAMASE

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jaxbrian
jaxbrian

ASKER

I am not sure I understand, I think I tried what you are saying to do but I have not been able to get it to work.
when I try to echo the array, it only says "array" I did this just as a test to see if there was any data there. when i submit the form with multiple emails it doesn't fail, it just doesn't insert them int to eh DB.


thank you, I will keep messing with it.
Output you vars with
print_r($variable);

Open in new window


or

var_dump($variable);

Open in new window

Avatar of Ovid Burke
Do you want to put multiple email addresses into one field in your database table? Or do you want to put them into separate records (rows)?

I need them to go into separate rows.

thanks for your time
B
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I could not get that script to work for the submission of emails. I am going to award points for your help with this. I realize now that I really need three form fields to be imported to MySQL. $first, $last, and $email and I guess that is really a new question.
I have tried to work with a foreach() and I just cant seem to get that to work either

thank you for every ones help with this