tomhoad Posted March 5, 2008 Share Posted March 5, 2008 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 Quote Link to comment Share on other sites More sharing options...
bpops Posted March 5, 2008 Share Posted March 5, 2008 Try using nl2br($content). It will convert your line breaks to <br> so that they display correctly in web browsers. (Remember html doesn't care about line breaks themselves) Quote Link to comment Share on other sites More sharing options...
tomhoad Posted March 5, 2008 Author Share Posted March 5, 2008 SOLVED. cheers Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.