Re: UPDATE part of a column

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

 



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

-- 
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