affordit2 Posted December 28, 2020 Share Posted December 28, 2020 I have a text box that I use to post comments and save them to my database. I can go to the database and the data I entered looks perfect but when I pull it out it all runs together. This is how I entered it and the way it is in the database: I have a text box that I use to post comments and save them to my database. I can go to the database, the data I entered looks perfect but when I pull it out and display it it all runs together. No new lines just all one paragraph. Can someone help? This is how it came out: I have a text box that I use to post comments and save them to my database. I can go to the database, the data I entered looks perfect but when I pull it out and display it it all runs together. No new lines just all one paragraph. Can someone help? I got it indenting the paragraphs, but I get all the data back I entered all in 1 paragraph, is there something I am missing to be able to recognize the new lines?? Quote Link to comment https://forums.phpfreaks.com/topic/311940-how-to-format-the-data-retreived-from-an-sql-query-with-php/ Share on other sites More sharing options...
desjardins Posted December 28, 2020 Share Posted December 28, 2020 (edited) format it with nl2br() Edited December 28, 2020 by desjardins Quote Link to comment https://forums.phpfreaks.com/topic/311940-how-to-format-the-data-retreived-from-an-sql-query-with-php/#findComment-1583482 Share on other sites More sharing options...
requinix Posted December 28, 2020 Share Posted December 28, 2020 ...using nl2br. 1 Quote Link to comment https://forums.phpfreaks.com/topic/311940-how-to-format-the-data-retreived-from-an-sql-query-with-php/#findComment-1583483 Share on other sites More sharing options...
affordit2 Posted December 28, 2020 Author Share Posted December 28, 2020 Thank you so much I could not remember that to save my life:):):) Quote Link to comment https://forums.phpfreaks.com/topic/311940-how-to-format-the-data-retreived-from-an-sql-query-with-php/#findComment-1583484 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.