$temp = str_replace("\n","[break]",$inpText); //inpText is from textArea and then u enter your temp to the sql.. when you want to split it up.. just use $temp=explode("[break]",$inp4Sql); //hope i don't give wrong function ==spam?? sory=== ----- Original Message ----- From: "Bill Bolte" <billb@xxxxxxxxxxxxxxxx> To: <php-windows@xxxxxxxxxxxxx> Sent: Friday, May 18, 2007 4:22 AM Subject: RE: Textarea and mysql Split the data on a line break maybe? First thing that comes into my head... -----Original Message----- From: Moore, Joshua [mailto:Joshua.Moore@xxxxxxxxx] Sent: Thursday, May 17, 2007 4:17 PM To: php-windows@xxxxxxxxxxxxx Subject: Textarea and mysql Hello, Im currently having a bit of an issue with putting user info from a textarea into mysql db with php. With the textarea I need each new line to be a separate entry into the db fields. So I guess the end result is making the textarea act like a regular text html form. The reason I am using textarea is because I want a user to paste in a long string of numbers Ex: 11111111 22222222 33333333 ...and so on And each will end up in the same field just different entries. Does anyone have any idea how I can accomplish this? Thanks -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php