Re: UPDATE part of a column
| From: | mike karthauser | Date: | Tue, 23 Sep 2003 12:24:46 +0000 |
| Subject: | Re: UPDATE part of a column | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30640@lists.php.net to get a copy of this message | ||
on 23/9/03 1:03 pm, Shaun at shaun@mania.plus.com wrote:
> 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?
Do something like this:
$pagetext=ereg_replace(" <BR>"," ",$pagetext);
To strip the <BR>s
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> mikek@brightstorm.co.uk
Web >> http://www.brightstorm.co.uk
Tel >> 0117 9426653 (office)
07939 252144 (mobile)
Snailmail >> Unit 8, 14 King Square,
Bristol BS2 8JJ