Hi, Does anyone know how to separate values in a text area field, to enter the separated values into a database?
For instance if enter these values into a text area field Dogs Cats Fish I want to be able to take Dogs, Cats and Fish and put them in different rows in a database. I guess the biggest problem I have is splitting the values in the text area field that is separated by a carriage return. Once I have that, and I know how to separate the values, then I can easily put them into a database. BTW I am using CGI/PERL to enter the values into a MySql database. Thanks for any advice Emma --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php