I have a mysql database with a paragraph save but every time i display/echo it out it shows like so The Funniest Thought - : ) "Always Smile in the Morning...... It makes people wonder that what u did last night..!!.." All in one line Is there any way to get it to keep the original format just like the way its saved in the database with all the breaks instead of having it display in just one line any help would be greatly appreciated Thanks
If you want to display it that way on a web page, the breaks have to be <br />, not line terminations. If you're using PHP, you can use echo nl2br($yourtexthere); That will convert the text from having line breaks to having HTML breaks.
Actually you have 2 options: 1. use nl2br for the output as Rukbat mentioned. 2. try using an HTML editor such as TyniMCE or CKEditor to edit that text. The Editor will automatically add breaking line tags for you! Good luck!