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