By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,404 Members | 1,937 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,404 IT Pros & Developers. It's quick & easy.

How to select mysql databases without changing distance between paragraphs?

P: 30
Hello friends
I have inserted some texts into mysql databse column. The databse structure for that column is 'text'. The updated texts into the database is below.

#Updated text:

***************START**************

Wushu is both an exhibition and a full-contact sport derived from traditional Chinese martial arts. It was developed in China after 1949, in an effort to standardize the practice of traditional Chinese martial arts, although attempts to structure the various decentralized martial arts traditions date back earlier, when the Central Guoshu Institute was established at Nanking in 1928. The term wushu is Chinese for "martial arts".



In contemporary times, wushu has become an international sport through the International Wushu Federation (IWUF), which holds the World Wushu Championships every two years; the first World Championships were held in 1991 in Beijing and won by Yuan Wen Qing.


*************END*************

I've updated two paragraphs.

When I try to select the database which are getting as a single paragraph as like this


****************Start*************

Wushu is both an exhibition and a full-contact sport derived from traditional Chinese martial arts. It was developed in China after 1949, in an effort to standardize the practice of traditional Chinese martial arts, although attempts to structure the various decentralized martial arts traditions date back earlier, when the Central Guoshu Institute was established at Nanking in 1928. The term wushu is Chinese for "martial arts".In contemporary times, wushu has become an international sport through the International Wushu Federation (IWUF), which holds the World Wushu Championships every two years; the first World Championships were held in 1991 in Beijing and won by Yuan Wen Qing.


****************END*******************



What is the way to getting as originally updated(with space) from database?
Oct 7 '14 #1
Share this Question
Share on Google+
1 Reply


mwasif
Expert 100+
P: 801
If you are using PHP to output data then use PHP function nl2br().

Line breaks are there in the text, you just need to output in proper format on an HTML page.
Dec 25 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.