Preserving formatting (mySQL and PHP)

[da_silvy]

Here's the go,
In a mysql database, i have stored code snippets.

however when i print out what is in the field (the code snippet field)

It prints out with no carriage returns, i.e.

'This code is for disabling resizing'Written by Matthew GatesOption Explicit

How do i fix that?

this is my current code

              $title = mysql_result ($result, 0, "title"); //Get the title
            $type = mysql_result ($result, 0, "type");
            $description = mysql_result ($result, 0, "description");
            $code = mysql_result ($result, 0, "code");
            echo "<center>$title</center><br>$vb<br>$description<br><br>$code"; 

[da_silvy]

Fixed that, new problem

I solved that with:

            $title = mysql_result ($result, 0, "title"); //Get the title
            $type = mysql_result ($result, 0, "type");
            $description = mysql_result ($result, 0, "description");
            $code = nl2br(mysql_result ($result, 0, "code"));
            echo "<center>$title</center><br>$vb<br>$description<br><br>$code"; 

Is there any way i can preserve tabs?

[scoutt]

what is the field type in Mysql for that categorie? like varchar or something

[da_silvy]

text

[scoutt]

if it is text then I don't see why it won't. I use text and it does preserve the tabs and breaks. are you stripping the htmlcharacters from it?

[da_silvy]

no

http://144.132.20.16/code/index.php?snippet=5

???

[scoutt]

ahhh I know why. I put mine in a text area and you aren't. the reason you don't is becasue the browser doesn't let it. you should insert the htmlspecial characters into it. like exchange the break for a <br> and exchange the so many spaces & nbsp; and make it so many spaces.

I ran into this but decided to put the code in a textarea and make it readonly so I can keep the formatting.

[da_silvy]

Thanks man, i'll try htmspecial'charring' it...

I wonder how John does it

[da_silvy]

Have a look at it now, -> no such luck

Still preserves line spacing, but can't get proper tabs.

Myphpadmin can in a textbox

I got it working in a scrolling text box, but i wanted to color code it i'll see if John replies

[scoutt]

yeah let me know, maybe he uses the <pre> tags. still let me know, might be something to keep in mind.

[da_silvy]

Yeah that worked.

Thanks man

Now i just need to get the [vbcode ] formatting code off john...