Database table data not being displayed in right format on browser

[Thuita Maina]

The contents of a mysql database table are being displayed as one continuous story without paragraphing (i.e. not being displayed in paragraphs). How do I correct the anomaly? Do I change the data types of the column or what? Note that the data is inserted into the database table via a html form. PLEASE HELP!

[abduraooft]

Have a look at http://php.net/nl2br

PS:

Originally Posted by http://www.codingforums.com/rules.htm

1.2) Do not crosspost- CodingForums.com is divided into various categories. When initiating a thread, always locate the most appropriate category, and post your question only ONCE, in that category. Do not post the same question in multiple categories.

[Thuita Maina]

Thanks Abduraooft for the reference and the PS: I will not crosspost again. I have however not grasped the use of nl2br() function. Where do I use it? Do I use it when I am inputting data into the database or when displaying in a browser? Below are the codes in my website that perform the aforementioned tasks (the particular table column I want paragraphed is in red). Please guide me on how I can make use of the nl2br() function.

INSERTING:

$sessionvariable = $_SESSION['names'];
$title = $_POST['title'];
date_default_timezone_set('Africa/Nairobi');
$datetime = date('Y/m/d H:i:s');
$stories = $_POST['stories'];

mysql_query("INSERT INTO  `a5846646_4f2005`.`stories` (
`id` ,
`names` ,
`Title` ,
`datetime` ,
`stories`
)
VALUES (
NULL ,  '$sessionvariable',  '$title',  '$datetime',  '$stories'
)");

RETRIEVING FOR DISPLAY ON BROWSER:

$id = $_GET['id']; 
$sql = "SELECT * FROM `stories` WHERE `id` ='$id' ";  
  
$result = mysql_query($sql) or die(mysql_error());  
  

 
    
        //display story data  
        while($row = mysql_fetch_assoc($result))  
        {  
            echo '<h2>Story title: ' . $row['title'] . '</h2><br>'; 
            echo '<h2>By: ' . $row['names'] .'</h2>'; 
            echo '<h2> on ' . $row['datetime'] . '</h2><br>';
            echo 'Story: ' . $row['stories'] . '<br>';   
        }

Thank in advance for your assistance.

Who said nothing is impossible while I have been doing nothing all this time?

[abduraooft]

PHP Code:

echo 'Story: ' . nl2br($row['stories']) . '<br>'; 


[Thuita Maina]

Thanks Abduraooft. It did it. Thanks for your thoughtful effort.