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