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

Reply via email to