RE: [PHP-DB] UPDATE part of a column

As a separate issue, I would consider seperating the address field into it's individual parts Street,area,city etc.. All different fields -----Original Message----- From: Shaun [mailto:shaun@mania.plus.com] Sent: Tuesday, September 23, 2003 2:03 PM To: php-db@lists.php.net Subject: [PHP-DB] UPDATE part of a column 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