Preserving formatting (mySQL and PHP)

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.

Code:

---

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

---

How do i fix that?

this is my current code

PHP 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"; 


---

Fixed that, new problem

I solved that with:

PHP Code:

---

            $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?

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

text

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?

no

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

???

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.

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

I wonder how John does it :rolleyes:

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 :rolleyes: i'll see if John replies ;)

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

Yeah that worked.

Thanks man

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