how to print on seperate lines

[iffoiffy]

Hi,

I my MYSQL table I have a field with a type longtext.

In that field I have data entered like

2 cat
2 dog
1 horse
5 mouse


when I retrive that from that table and echo the variable

it gets printed like
2 cat 2 dog 1 horse 5 mouse

How can I print it the same way on seperate lines as it was in the database?

Thanks

 

[jpadie]

add a [bode]<br />[/code] after each line of your output within the loop.

 

[DRJ478]

You have to consider that HTML is white space agnostic. Linbreaks are not intepreted in HTML.
You need to create valid HTML structure, including <br /> tags, wrap in <p> ...</p>.
If you inspect the source code, you'll se that the linbreaks are actually there.
A quick way to translate the newline chars into breaks is the function nl2br($string).