Jump to content

how to re-justify/format text from mysql


snowy190uk

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.
Link to comment
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.
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.