Re: UPDATE part of a column

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

 



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


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

  Powered by Linux