Paste problem

[HueyJib]

Hi.

 

I scripted my own pastebin site in php and I'm using a mysql database to store pastes. The problem is, I post the content like this:

 

This

Is

The

Content

 

And it shows up just like that in the db table. Now, when I echo that content to the site, it shows up like this:

 

This Is The Content

 

How do I fix that?

 

This is what I use to get the info from the table.

$host="...";
$username="...";
$password="...";
$db_name="...";
$tbl_name="...";

mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$pn=$_GET['pn'];

$sql="SELECT * FROM $tbl_name WHERE pn='$pn'";
$result=mysql_query($sql);

$rows=mysql_fetch_array($result);

<tr>
<td width="100%" align="center" bgcolor="#E6E6E6"><font face="Verdana" size="2"><strong>Content</strong></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><font face="Verdana" size="2"><? echo $rows['text']; ?></font></td>
</tr>

[mrMarcus]

use nl2br();

 

this will store the integrity of your line breaks.

 

http://ca.php.net/manual/en/function.nl2br.php

 

it should help.

[HueyJib]

use nl2br();

 

this will store the integrity of your line breaks.

 

http://ca.php.net/manual/en/function.nl2br.php

 

it should help.

Aha! It worked. Thank you very much. 

[HueyJib]

Sorry for double post but I have a new question.

 

One time I pasted a php/html code and it turned out it actually did the code as if I wanted it to work. For example, if I pasted this:

<a href="http://www.phpfreaks.com/forums">PHP Help Forum</a>

 

It would come out like this:

PHP Help Forum

 

How do I turn script code into raw text so it doesn't do the example above.

[Stefan]

If I recall correctly    than the html tags are <pre>your code here</pre>!

 

This should keep all formatting and display as plain text or something of the like . .

[mrMarcus]

Sorry for double post but I have a new question.

 

One time I pasted a php/html code and it turned out it actually did the code as if I wanted it to work. For example, if I pasted this:

<a href="http://www.phpfreaks.com/forums">PHP Help Forum</a>

 

It would come out like this:

PHP Help Forum

 

How do I turn script code into raw text so it doesn't do the example above.

i guess it kinda depends on how you want it to be viewed/stored.  do you just want the link name and not the href attached with it?

[Stefan]

Ooops! Sorry about that!

 

I wrote, use tags 'pre and end pre'

or try this link

http://www.w3schools.com/TAGS/tag_pre.asp but mrMarcus has a point!