Re: UPDATE part of a column
| From: | Jo�o C�ndido de Souza Neto | Date: | Tue, 23 Sep 2003 14:15:07 +0000 |
| Subject: | Re: UPDATE part of a column | ||
| References: | 1 | Groups: | php.db php.db |
| Request: | Send a blank email to php-db+get-30643@lists.php.net to get a copy of this message | ||
Can you use strip_tags(nl2br($textarea))
"Shaun" <shaun@mania.plus.com> escreveu na mensagem
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