Concatenation and \n\r

[The_Chancer]

I am a little confused and any light shed on this would be grateful...

the code

include('db.php');
$result=do_query("SELECT * FROM enquiry WHERE ref='310'");
while($enquiry=mssql_fetch_array($result))
{
	if (!($enquiry["clientref"]==$clientref))
	{
		$changes=$enquiry["changes"]."\n".date("d M y", time())." Client Ref changed";
		$update=do_query("UPDATE enquiry SET changes=\"$changes\" WHERE ref='310'");
		print("$changes");
		exit;
	}
}

Should produce something like
date what went before
date client ref changed

But it doesn't.. it produces...
date what went before date client ref changed

Simple I know, but I'm buggered if I know...

Any help...

[Weedpacket]

You're viewing it in a browser, aren't you? As HTML, right?

Helpful hint: <br>

[The_Chancer]

Very true, and with <br> instead of \n it does work. However does it matter that I am storing the data as well ?

[Weedpacket]

Store it with a \n, then. There's a PHP function to convert that into an HTML break tag when you want to display it.

[The_Chancer]

That would be the trusty nl2br then....