The best way to do this is a text field, NOT a textarea, and if need be, use multiple fields. A textarea, by look and definition is inviting carriage returns to be used. Limit the users to the input you want, and remember, GIGO (garbage in, garbage out)
Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 "Pay It Forward" mailto:[EMAIL PROTECTED] http://accessingram.com > -----Original Message----- > From: João Cândido de Souza Neto [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 23, 2003 9:15 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: [PHP-DB] Re: UPDATE part of a column > > > Can you use strip_tags(nl2br($textarea)) > > "Shaun" <[EMAIL PROTECTED]> escreveu na mensagem > news:[EMAIL PROTECTED] > > Hi, > > > > I have a column in my table called address. When users add > an address with > a > > textarea they sometimes press return for a new line and > this seems to be > > putting line breaks into the database, so I have 2 questions: > > > > 1. How can I clean the table, so for example changing: > > Ashfield Business Centre<BR> The Idlewells Precinct<BR> > > Sutton-in-Ashfield<BR> > > to: > > Ashfield Business Centre, The Idlewells Precinct, > Sutton-in-Ashfield, > > > > 2, Is there a way to make sure the data is 'clean' before > entering into > the > > table? > > > > Thanks for your help > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >
