Preserving paragraphs from form input to database to on page display

[webref.eu]

Hi All

 

If I input this into my textarea on my form: 

 

This is the first paragraph.  

This is the second paragraph.  

This is the third paragraph.

 

i.e. I have put some line breaks into my input, when I look at the input in MySQL Query Browser I can see two (line break?) characters between each line as shown graphically in my attachment. 

 

Presently, when I pull the text out from my database and display on page, then the line breaks are not being preserved. 

 

So, how do I get the line breaks to be recognised when I redisplay the text?

 

Thanks all. 

 

[attachment deleted by admin]

[webref.eu]

OK, so I've found the nl2br function, which works: 

 

nl2br($row[ReviewDesc])

 

is this the best practice method? 

 

Many thanks.

[Barand]

It's certainly the easiest and most common.