UPDATE part of a column

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux