I have a DB system which i've just rewritten for a travel website. Previously it used <BR>'s for linebreaks but i've made it much more efficient. My problem it, there are 10+ travel guides which us <BR>'s and I want to remove them on over 100 pages (In a MySQL DB).
Using PHP, how can I write a simple script to go through all the entries for a column (Called articles) and remove all instances of <br> or <BR> ??? It would take far too long to do it page by page :-(
I know this is a PHP list, but why use PHP?
UPDATE table SET column = REPLACE(column,'<BR>',''); UPDATE table SET column = REPLACE(column,'<br>','');
-- ---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
PHP|Architect: A magazine for PHP Professionals – www.phparch.com
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
