473,383 Members | 1,843 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

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 1232
mwasif
802 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

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

Similar topics

11
by: Joshua Beall | last post by:
Hi All, I am working on a registration system, and one of the things I am going to need to be able to do it setup the database tables for each event that I have registration for. Normally I...
3
by: Ron Brennan | last post by:
Good morning. I have a page displayed and want to get information from a user using showModalDialog, and then send a request to the server for more information based on the user info from the...
2
by: Don | last post by:
is there any way to disable the controls on a form without changing their appearance? i would like to make it impossible for a user to click buttons and edit text boxes while the controls retain...
1
by: vineyard_saker | last post by:
Hi, I am new to MySql and I want to practice querying by playing around a relatively large and complex database without having to enter all the data myself. Is there a publicly available MySql...
16
by: StenKoll | last post by:
Help needed in order to create a register of stocks in a company. In accordance with local laws I need to give each individual share a number. I have accomplished this by establishing three tables...
2
by: S P Arif Sahari Wibowo | last post by:
Hi! Do you know how to put a form's Access-Visual-Basic-code that will force the form to be inserted, while the user has not type anything in the form, without changing focus, selection, etc.? ...
1
by: Linda | last post by:
Hi, Is there a way to do a "text" (rather than "binary") compareison with the "like" operator, without changing the global "Option Compare" setting? I don't want to risk breaking many, many...
9
by: noor.rahman | last post by:
I was wondering how it may be possible to query 2 MySQL databases using one query statement from PHP. For instance: SELECT database1.tableA.field1 UNION database2.tableB.field2. My concern...
1
by: nrajeshatwork | last post by:
Hi I need to print a page without header and footer. Can it be done without changing the page settings in the browser. If so plz mail me. Regards,
4
by: dertopper | last post by:
Hello newsgroup, is it possible to create a std::locale object without changing the global C locale? Is this implementation defined? My problem is that I work in a multi-threaded environment...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.