I can't seem to search the forums at the moment, so apologies if there is another thread addressing my problem.
According to phpMyAdmin, the text from a text box is being stored correctly, line breaks 'n' all.
However, upon echoing the data, the "content" is printed on one line.
<?php
include 'secure/config.php';
include 'secure/opendb.php';
$query = "SELECT id, title, content, FROM_UNIXTIME(date, '%W %D %M %Y at %h:%i %p') as dttm
FROM news ORDER BY id DESC LIMIT 3";
$result = mysql_query($query) or die('Error : ' . mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$title = $row['title'];
$content = $row['content'];
$dttm = $row['dttm'];
echo stripslashes (
'
<p class="news-header">'.$title.'</p>
<p class="news-body">'.$content.'</p>
<p class="news-footer">Posted on: '.$dttm.'</p>
<br>
'
);
}
?>
What have I missed out?
thank you
