mysql takes no "return key" input

[thimble]

Hi,

I'm writing a very simple guestbook script, cause i'm in no need of an advanced.

My problem is : when you type into the message field and hit the return key (enter) it will begin typing on a new line.

But when i view my guestbook, all the text in the message field comes on one line. In my MySQL database a field of the type "text" is used for the message field.

What kind of properties do i need to set? or actions do i need to take in order to get the output with the returns of the guestbook user?
Most simple sample guestbooks i saw had the same problem...

Tia,

Johan

[[deleted]]

http://www.hvt-automation.nl/yapf/index.php?cmd=viewitem&itemid=8

[thimble]

Hi,

Thanks for your reply but that's not exactly what i was looking for... (i think)

I down't want to ask the guestbook users to type a "\n" instead of hitting the return key.

Its like this:
I have a form. In this form a message field in a html page wich is posted to a php file.

This php file puts the written text in the form textfield into a database.

Now the problem is when you type a nice text in there and give it some layout by using returns and tabs, it's simply stocked into the database without returns and so.
When i print the field on a php page the whole text comes on one line...

How do i solve that with "\n" ?

Thanx,
Johan

[thimble]

Ahaaaaaa,

!!Forget the last message!!
I got the picture :-) , it works!

Thanx a lot man!
Johan