select query adds line break

[Swedie]

This is my very simple code...

$sql = mysql_query("SELECT * FROM table WHERE id = '1' LIMIT 1");
$array = mysql_fetch_assoc($sql);

the problem is that each field that is a textfield has a line break after them.

$array['field'] = "test
";

like that... that's the output. With a line break...
I can't strip out the line break using
str_replace("\n", "", $value);

it doesn't even detect it...

but I see it in my html code and my forms which includes the line break causing the code to use incorrect inputs...

I just don't understand what is causing it. Anyone here encountered this problem?

[paulnaj]

Try stripping out \r as well as \n ...

str_replace("\n", "", str_replace("\r", "", $value));

P.

[Swedie]

yep! did that to the $value and it works now.

The wierd thing is that this doesn't happen to all values, just a few... in the same query. But always the same.

Why? Would be nice to know.

is there an explaination somewhere on the \r thingy? (recursive i guess)

[paulnaj]

It's to do with how all the os's interpret a newline, although I can never remember which is which.
One uses just "\n"
One uses just "\r"
One uses both "\r\n"

So strip both out and you're covered.

Also, I think it's the textarea's that cause the problem, rather that input-texts.

P.

[bradgrafelman]

More simply, you could just use [man]trim/man.

$value = trim($value);

Also, just in case you're curious...

Mac - \r
Windows - \r\n
Unix - \n

[paulnaj]

Hi Brad,

Always a quicker way! Forgot about trim().

P.