Jump to content


Photo

Multiple Insert Help Please


  • Please log in to reply
2 replies to this topic

#1 chanw1

chanw1
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 29 October 2006 - 02:20 AM

Hi

I need some help with multiple row insert into a table

I a have form with a TextArea.

I need to enter in email addresses into the Text Area on the form and when it is submitted it inserts into each separate email into multiple rows.

Any help with this would be greatly appreciated.

Thanks



#2 jwk811

jwk811
  • Members
  • PipPipPip
  • Advanced Member
  • 714 posts

Posted 29 October 2006 - 03:39 AM

i might be able to help you but i dont understand what you're trying to do

#3 Psycho

Psycho
  • Moderators
  • Move along, nothing to see here
  • 11,892 posts
  • LocationCanada

Posted 29 October 2006 - 05:54 AM

If I understand him correctly he has a textarea where the user can enter multiple email addresses and he wants to enter each email address into the database separately.

The questin to you is how are the email addresses delimited in the text field. Are they entered on one line, separated by a delimiter such as a comma, or what? If you can't control how the user will enter them you will need to use some regular expressions to determine where one email address ends and another begins.
The quality of the responses received is directly proportional to the quality of the question asked.

I do not always test the code I provide, so there may be some syntax errors. In 99% of all cases I found the solution to your problem here: http://www.php.net




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users