Jump to content

newlines not showing up when info previously stored in DB is displayed on page


newbeee

Recommended Posts

the news field in my database is a text type

 

what i wish to know is how to have text that has line breaks within the text

still show with these line breaks when i grab the data again to show it in the page it is ment for.

 

at the moment all the text seems to just continue on one long line and breaks up when the end of the page is reached.

 

edit file

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?
include("config.php");

if($_POST['submit'] == "submit") {
$update = mysql_query("UPDATE `news` SET `news` = '" . $_POST['news'] . "'");
} else {
$news = mysql_query("SELECT * FROM `news`");
?>
<textarea name="news" cols="80" rows="10"><?=@mysql_result($news, 0, 'news');?></textarea><br>
<input name="submit" type="submit" value="submit">
<?
}
?>
</body>
</html>

 

display page

<?=@mysql_result($mpsurgeries_news, 0, "mpsurgeries_news");?>

Link to post
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.