[Show all top banners]

ma_ko_hoo
Replies to this thread:

More by ma_ko_hoo
What people are reading
Subscribers
:: Subscribe
Back to: Kurakani General Refresh page to view new replies
 can any one help me in mysql-php
[VIEWED 6387 TIMES]
SAVE! for ease of future access.
Posted on 12-14-06 4:18 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

i displayed a few paragraph in my web page which was stored in the mysql table as a blob, but it was not displayed as a paragraph ( with no enter, in single line). Can some one help me if there is an extra code needed to display it correctly.

EX:
this is first para
this is second para
this is third para

above is the stored blob type content

when it is displayed it shows like
this is first para this is second para this is third para

Now i need to correct this, can any one have any idea.
 
Posted on 12-14-06 11:10 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

did you store it as html?? or just plain text?
 
Posted on 12-14-06 11:12 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

if you saved it as plain text, in html, try displaying the blob inside the
 
tags.

normally, its better to save it as html
 
Posted on 12-14-06 11:23 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

ma_ko_hoo bro use nl2br function...like this

echo nl2br(mysql_field_name)..
 
Posted on 12-14-06 12:10 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

another way.....

use
echo ereg_replace("\n","
", mysql_field_name);

which will replaces all newline charecters (\n) to html tag.
 
Posted on 12-14-06 12:12 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

sorry, line break tag did not show up in above post

echo ereg_replace("\n","<br>", mysql_field_name);
 
Posted on 12-14-06 11:09 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

Thanks buddies, I will try as suggested.
 


Please Log in! to be able to reply! If you don't have a login, please register here.

YOU CAN ALSO



IN ORDER TO POST!




Within last 365 days
Recommended Popular Threads Controvertial Threads
NRN card pros and cons?
ANA and AJAY KUMAR DEV. RAPISTS CONVENTION
TPS To F-1 COS
TPS to F1 Status.
Nepal TPS has been Extended !!!
legal Query for married nepali girl now have taken US citizenship
Got my F1 reinstatement approved within 3 months(was out of F1 for almost 2 years)
ICE kidnapping people off the streets over op eds
Democrat wants to run election like in India. Chaos and Confusing to voters.
2020 : Why No Trump !
#MAGA#FAFO is delicious
TPS of Nepal to be automatically extended for 6 months based on South Sudan decision
Breaking News: Ninth Circuit Rejects Government Bid to Undo Nepal TPS Order, Leaves Protections in Place
Democrat lies revealed
Nepal TPS decision
Has anyone here successfully reinstated to F-1 status after a year-long gap following a drop from F-1?
US citizen Petitioning my wife who was out of status when she was in H1B. What to do ?
TPS Sakiyo Tara Case is in Court.
Medication from Nepal to USA
Supreme Court allows Trump to end TPS for Venezuelans
NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters