Displaying text with character returns

[Jon12345]

I have a form where I can enter multiple liines of text into a MySQL database. However, when I try to display this text on a webpage, it does not display the text with appropriate paragraphs.

Do I need to do something to the text before outputting it?

The output page is below:

<?
$dbh=mysql_connect ("localhost", "alwaysac", "xxx") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("alwaysac_MyArticles"); 

$result = mysql_query("SELECT * FROM Articles WHERE id='".$id."'");
$row = mysql_fetch_assoc($result);

echo "TopicName = ".$row['TopicName'];
echo "<br>";
echo "MetaTitle = ".$row['MetaTitle'];
echo "<br>";
echo "MetaDesc = ".$row['MetaDesc'];
echo "<br>";
echo "TopicTitle = ".$row['TopicTitle'];
echo "<br>";
echo "TopicBody = ".$row['TopicBody'];
echo "<br>";
echo "Advert = ".$row['Advert'];

mysql_close($dbh);
?>

[vaaaska]

Originally posted by Jon12345
Do I need to do something to the text before outputting it?

Probably...but it's hard to say exactly...how is it being saved to the db?

Plus, you have passwords in there...I would suggest going back and editing those out of your post...

[Jon12345]

Passwords are incorrect now. 😃

It is just being stored in the database by using an INSERT statement.

<?
$dbh=mysql_connect ("localhost", "alwaysac", "xxx") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("alwaysac_MyArticles"); 
mysql_query("insert into Articles(TopicName, MetaTitle, MetaDesc, TopicTitle, TopicBody, Advert) values('$TopicName', '$MetaTitle', '$MetaDesc', '$TopicTitle', '$TopicBody', '$Advert')"); 
mysql_close($dbh);

header("Location: /pealist.php"); 
?>

[vaaaska]

???

However, when I try to display this text on a webpage, it does not display the text with appropriate paragraphs.

What paragraphs do you want? <p> tags? You are using <br> tags...

[Skull]

change

$row['TopicBody']

to

nl2br($row['TopicBody'])

[Jon12345]

That worked. Thanks! 😃