PHP retrieveing from SQL but forgetting linebreaks?

Question

I'm using a Textarea element to allow users to update their "status".

All works fine but new lines disapear when I retrieve the text from the SQL? It SAVES them ok, and I can see them in PhpMyAdmin, but when I run this code after retrieving all the updates:

while($row = mysql_fetch_array($StatusResult))
{
  echo $row['Text'];
  if (GetLoggedOnId() == $_GET["UId"])
  {
    echo "<form>
          <input type=\"submit\" value=\"X\" name=\"REMOVE\"/>
          </form>";
  }
  echo "<br/>";
}

it seems to just "forget" where linebreaks were.

Bas Slagter · Accepted Answer · 2011-05-24 21:03:41Z

6

Try this method when printing the string: nl2br

answered May 24, 2011 at 21:03

Bas Slagter

9,9479 gold badges49 silver badges81 bronze badges

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

3 Comments

Ashley Davies Over a year ago

Thanks. I'm not sure whether to accept your answer or Arjan's, since you both gave a working answer at almost the same time.. :/. Wish we could accept two.

Bas Slagter Over a year ago

Do what feels the best for you. Glad I could help.

Ashley Davies Over a year ago

I suppose I'll go with Baszz, since he has less reputation.

Arjan · Accepted Answer · 2011-05-24 21:04:05Z

3

HTML ignores newline characters. Use nl2br() to convert the newline characters to <br> breaks that will display as expected in HTML.

answered May 24, 2011 at 21:04

Arjan

9,8941 gold badge33 silver badges43 bronze badges

Collectives™ on Stack Overflow

PHP retrieveing from SQL but forgetting linebreaks?

2 Answers 2

3 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Related