468,469 Members | 2,199 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,469 developers. It's quick & easy.

How to select mysql databases without changing distance between paragraphs?

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
1 1134
mwasif
801 Expert 512MB
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.

Similar topics

11 posts views Thread by Joshua Beall | last post: by
3 posts views Thread by Ron Brennan | last post: by
1 post views Thread by vineyard_saker | last post: by
9 posts views Thread by noor.rahman | last post: by
4 posts views Thread by dertopper | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.