Since '\n' is ignored in HTML, that is not your problem.
The answer is probably in your PHP setup or code.
Kenneth Porter wrote:
Using Red Hat 8.0, mysql-3.23.52-3, and phpMyAdmin-2.3.3.
I'm importing a bunch of old posts from one bboard system (Ezboards) into a
new one (Burning Board), and the process left a bunch of HTML "<br>" on the
end of each line that is now unwanted. (I'm getting double-spacing.)
I figured this SQL should remove the extraneous breaks:
UPDATE `bb1_posts` SET message = REPLACE(message,'<br>\n','\n') WHERE 1;
message is a text field usually with multiple lines in a record.
Alas, this doesn't seem to find the records that appear in the phpMyAdmin
browser with this characteristic, and I get zero records updated. What
could I be doing wrong?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php