[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 3533 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 90 days
Recommended Popular Threads Controvertial Threads
TPS Re-registration case still pending ..
Toilet paper or water?
and it begins - on Day 1 Trump will begin operations to deport millions of undocumented immigrants
Tourist Visa - Seeking Suggestions and Guidance
From Trump “I will revoke TPS, and deport them back to their country.”
I hope all the fake Nepali refugee get deported
advanced parole
Sajha Poll: Who is your favorite Nepali actress?
ढ्याउ गर्दा दसैँको खसी गनाउच
To Sajha admin
Problems of Nepalese students in US
Mamta kafle bhatt is still missing
अरुणिमाले दोस्रो पोई भेट्टाइछिन्
seriously, when applying for tech jobs in TPS, what you guys say when they ask if you have green card?
MAGA denaturalization proposal!!
Are Nepalese cheapstakes?
Nepali Psycho
How to Retrieve a Copy of Domestic Violence Complaint???
wanna be ruled by stupid or an Idiot ?
Travel Document for TPS (approved)
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