Line failing to brake

[Logician]

Does anyone know why I am not getting lines brakes when using \n when inserting the following into a MySQL field?

 

'".date(DATE_RFC822)."\nWRITING ORDER TO DATABASE\n'

[trq]

Not without seeing your code.

[Logician]

I've narrowed it down to being MySQL, because when I try to insert directly, it still doesn't work. The code I am using is:

INSERT INTO orders (test) values ('FOO\nBAR\n');

 

It should be sitting:

foo

bar

[trq]

\n means nothing to MySql.

[Logician]

I see. Damn it! Do you know how making a line brake can be done in MySQL?

[floridaflatlander]

What do you want a line break in mysql or a line break on a web page?

[haku]

Exactly. Are you looking at it in a mysql GUI? Or are you printing it to a page? Or to a file?

 

Also, it's 'break', not 'brake'

[fenway]

Nothing wrong with the line break -- but unless you're getting a mysql error, you have some other, non-DB problem.

[Logician]

OK, I am back on using MySQL with PHP again. This is what I just tried. Its being entered into the MySQL field, but there are not line brakes.

 

$query = "INSERT INTO orders (events) VALUES ('".date(DATE_RFC822)."\nWRITING ORDER TO DATABASE\n')";

[Logician]

So, it was working all along. I only noticed now when I checked MySQL from terminal. I got it working the way I needed it using the HTML element <PRE>

 

Solved.

[haku]

I'm assuming you mean that the line breaks weren't happening in your HTML (you still haven't really explained). If so, and you are using PHP, you can use nl2br() to convert line breaks to <br /> tags. You won't have to use <pre> tags this way.