Jump to content

Archived

This topic is now archived and is closed to further replies.

snowy190uk

how to re-justify/format text from mysql

Recommended Posts

Hi there,

I'm setting up really simple website for a youth orginisation where people can add ideas for games/crafts. I'm using mysql and php.

I've got it all working apart from when I do a query and display what someone has typed in. In PHPadmin the 'justification' is all there - spaces, extra 'returned' lines and paragraph end's. (like in this text). However when I query the mysql database and display an entry it all comes out totally unjustified - like its lost all of the returns etc...

Is there anyway of changing this? I'm starting to think its how the text is stored in the mysql database, or perhaps how its uploaded - but I don't know what to change to get it working!!

Any help would be great!

Cheers,
Chris.

Share this post


Link to post
Share on other sites
You need to apply the nl2br() function to the output.

echo nl2br($row['stuff']); will display the results with all the "returns" and whatnot put in there like it was entered.

Justifying in terms of alignment is all done in your CSS/styling and has nothing to do with the mysql output.

Share this post


Link to post
Share on other sites
aahhhh - pure relief!! Thanks for that - it's one area i've not covered before.

Many thanks once again,
Chris.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.