One more SQL question re: Linebreaks
 

So I have a bunch of data in an SQL database (Recipes) that is laid out like this:

3 TBSP Peanut Oil.
1/2 Cup Popcorn Kernels.
1/2 TSP Salt.
1/4 Cup Cheddar Cheese (Shredded).
1/4 Cup Parmesan Cheese (Grated).
1/4 Cup Pecorino Romano (Grated).

I also have another column for the recipe directions:

In a large metal 6 quart mixing bowl, place the oil, popcorn and salt, cover with aluminum foil and poke a few small holes in the top. Place the bowl over medium heat and shake constantly using a pair or tongs or heatproof gloves to hold the bowl. Continue shaking until the popcorn stops popping, roughly 3 minutes. Remove the bowl from the heat and carefully remove the aluminum foil, stir in any salt that remains on the side of the bowl. Place cooked popcorn on a parchment lined baking sheet (you might need to do this in batches) and sprinkle the shredded cheeses over the top, bake for 3 minutes in preheated oven, until cheese melts. Serve immediately.

How do I make it so that instead of being displayed as a solid block of text, after each period, a new line starts?

I was under the impression I could just do a search and replace for period [.] and replace it with this [\r\n] but that does not seem to be working as it still displays in a solid block of the ingredients and a different block for the recipe instructions all without new line breaks.

I also tried \n and \r on their own with the same results :Oh crap

I'd prefer to get the SQL data formatted correctly, rather than keep adding to .php functions on the page if at all possible as I don't want to put too much strain on the server from pulling php related functions on thousands upon thousands of pages.

Any idea what I'm doing wrong?

I might have smoked too much, but would char(10) do it? Line feed

I'll give that a try now, was under the impression that was only for use in formulas though :2 cents:

BRB...

Oh maybe. If that's the case, then don't pay attention to me :upsidedow

Now it is the same but I've lost the period marks and it shows char(10) so I either messed something up, or it doesn't work... Both are possible LOL

Going to do some more research into char(10) and see if that or char(13) will do what I need it to, thanks :)

I think char(13) brings the cursor to the beginning, but no new line.

So using the <pre> tag shows it how I need it to so I think I'm just going to add to the style sheet and hope for the best, I replaced . for [CTRL + SHIFT] J in excel and imported the data again and that 'seems' to be doing what I need.

Thanks for the nudge in the right direction to find a solution :thumbsup

Sure, hope it works. :)
I've wanted to try recipe sites but then it seems overwhelming lol, good luck!

\r and \n are not html linebreaks.

I suggest doing something like replacing "." with ".<br>", or explode() on ".' and then foreach the array in a <ul>

this ^^^^

.

Awesome, thank you so much!

Shouldn't the data be stored with linebreaks and then html formatting added upon display? :helpme