Publisher Bucks

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

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?

Colmike9

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

__________________
Join the BEST cam affiliate program on the internet!
I've referred over $1.7mil in spending this past year, you should join in.
I make a lot more money in the medical field in a lab now, fuck you guys. Don't ask me to come back, but do join Chaturbate in my sig, it still makes bank without me touching shit for years..

Publisher Bucks

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

BRB...

Colmike9

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

__________________
Join the BEST cam affiliate program on the internet!
I've referred over $1.7mil in spending this past year, you should join in.
I make a lot more money in the medical field in a lab now, fuck you guys. Don't ask me to come back, but do join Chaturbate in my sig, it still makes bank without me touching shit for years..

Publisher Bucks

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

Colmike9

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

__________________
Join the BEST cam affiliate program on the internet!
I've referred over $1.7mil in spending this past year, you should join in.
I make a lot more money in the medical field in a lab now, fuck you guys. Don't ask me to come back, but do join Chaturbate in my sig, it still makes bank without me touching shit for years..

Publisher Bucks

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

Colmike9

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

__________________
Join the BEST cam affiliate program on the internet!
I've referred over $1.7mil in spending this past year, you should join in.
I make a lot more money in the medical field in a lab now, fuck you guys. Don't ask me to come back, but do join Chaturbate in my sig, it still makes bank without me touching shit for years..

k0nr4d

\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>

__________________
Mechanical Bunny Media
Mechbunny Tube Script | Mechbunny Webcam Aggregator Script | Custom Web Development

sarettah

this ^^^^

.

__________________
All cookies cleared!

Publisher Bucks

Awesome, thank you so much!

fuzebox

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