--On Tuesday, December 03, 2002 12:14 PM -0500 Keith C. Ivey
[EMAIL PROTECTED] wrote:
My first guess is that you have CRLF where you think you've got just
LF. Have you tried the query with '\r\n' in place of '\n'?
That was it. I guess the data must have been imported from source that was
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
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
On 3 Dec 2002, at 6:29, Kenneth Porter wrote:
I figured this SQL should remove the extraneous breaks:
UPDATE `bb1_posts` SET message = REPLACE(message,'br\n','\n') WHERE 1;
My first guess is that you have CRLF where you think you've got just
LF. Have you tried the query with '\r\n' in