[jsad]

Hi,

I already have an existing table with 159 rows in it. "Title", "Summary" "Date" I now want to add a new column with text that must keep it's origional formating. This is all info that I have and will be entered by me.

I'm not really sure how to have the text keep it's formatting. Any advice on how to do this somewhat efficiently as it has to be entered 159 different times?

Thanks

[NeverMind]

go ahead!
add the column using phpmyadmin and you shouldn't have any problem ..
but what do you mean by formatting?

[jsad]

I mean if I have this text to enter

Code:

 Hello.
I am John.

I want it to look like that. By default it will put it all on one line.

Code:

 Hello. I am John.

[jsad]

I tired to edit my post instead of double posting but I could't find the edit button

Anyways, I figured it out. For anyone else with a siliar problem all I did was use nl2br()

PHP Code:

nl2br($row_guide['Summary']) 

[Sabu]

The nl2br will turn

Code:

Hello
   I am John

into

Code:

Hello
I am John

But if you want the spaces before the second line in place, you might consider using the <pre></pre> tags, so you won't need to replace the new lines at all. The only downfall being the dodgy preformatted font, which chooses the most appropriate font for same-width characters.