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:gary.every@ingramentertainment.com http://accessingram.com > -----Original Message----- > From: João Cândido de Souza Neto [mailto:joao@mrmidia.com.br] > Sent: Tuesday, September 23, 2003 9:15 AM > To: php-db@lists.php.net; php-db@lists.php.net > Subject: Re: UPDATE part of a column > > > Can you use strip_tags(nl2br($textarea)) > > "Shaun" <shaun@mania.plus.com> escreveu na mensagem > 20030923120310.50956.qmail@pb1.pair.com">news:20030923120310.50956.qmail@pb1.pair.com... > > 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 >
