snowy190uk Posted March 23, 2006 Share Posted March 23, 2006 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 https://forums.phpfreaks.com/topic/5594-how-to-re-justifyformat-text-from-mysql/ Share on other sites More sharing options...
ober Posted March 23, 2006 Share Posted March 23, 2006 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 https://forums.phpfreaks.com/topic/5594-how-to-re-justifyformat-text-from-mysql/#findComment-19950 Share on other sites More sharing options...
snowy190uk Posted March 23, 2006 Author Share Posted March 23, 2006 aahhhh - pure relief!! Thanks for that - it's one area i've not covered before.Many thanks once again,Chris. Link to comment https://forums.phpfreaks.com/topic/5594-how-to-re-justifyformat-text-from-mysql/#findComment-19955 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.