RE: Re: UPDATE part of a column

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

 



The best way to do this is a text field, NOT a textarea, and if need be, use
multiple fields. A textarea, by look and definition is inviting carriage
returns to be used. Limit the users to the input you want, and remember,
GIGO (garbage in, garbage out)


Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:gary.every@ingramentertainment.com
http://accessingram.com


> -----Original Message-----
> From: João Cândido de Souza Neto [mailto:joao@mrmidia.com.br]
> Sent: Tuesday, September 23, 2003 9:15 AM
> To: php-db@lists.php.net; php-db@lists.php.net
> Subject:  Re: UPDATE part of a column
> 
> 
> 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