line breaks and paragraphs

inash

Hello,

I just found out that in order to get your paragraphs to be formatted properly when you retrieve text from a database to display on a page you should use something called

echo nl2br( $text_from_database );

My question is, where exactly do I use this command? Do I include it in the PHP file itself, and if so, where does it go?

Or do I type it directly as a command line when I connect to my database using my ssh program?

Thanks in advance

Traduim

You should use nl2br when you print text out of database to the "screen" of visitors.

<?
$myquery =mysql_query("SELECT whatever FROM wherever WHERE something happen");

while ($row = mysql_fetch_row($myquery)){
print nl2br($row[0]);
}
?>

inash

Hello, and thanks for the tip. I tried it though and got an error message when the page tried to load up.

Here's all my php script. I'd really appreciate it if you could let me know exactly what should go where. AS you can tell, I'm very new at all this!

Thanks again!

<?
// includes
include("conf.php");
include("functions.php");

// open database connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

// select database
mysql_select_db($db) or die ("Unable to select database!");

// generate and execute query
$query = "SELECT articletitle, articlelead, articletext FROM articles WHERE id = '$id'";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

// get resultset as object
$row = mysql_fetch_object($result);

// print details
if ($row)
{
?>

<? echo $row->articletitle; ?>
 

<? echo $row->articletext; ?>

 
<?
}
else
{
?>

 The article
could not be located in the database. 
<?
}

// close database connection
mysql_close($connection);
?>