Echo from MySQL database with spaces and line breaks?

Question

I noticed that when I submit text to my MySQL form in VARCHAR it does store line breaks. (Since they show in PHPMyAdmin). However when I echo column Text, I get everything in a single line.

How can I echo values retaining line breaks?

it does store line breaks, but html interpreters (browsers) do not do anything with them, you need the html equivalent of <br> — user557846
– user557846, Commented Feb 26, 2012 at 22:38

Ignacio Vazquez-Abrams · Accepted Answer · 2012-02-26 22:29:03Z

5

nl2br()

answered Feb 26, 2012 at 22:29

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

codegenin · Accepted Answer · 2012-02-26 22:35:25Z

1

have you tried http://php.net/manual/en/function.nl2br.php

answered Feb 26, 2012 at 22:35

codegenin

4504 silver badges14 bronze badges

Collectives™ on Stack Overflow

Echo from MySQL database with spaces and line breaks?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related