Products_Description not showing up correctly

[Vixay]

After searching the forums, I haven't found any help with my problem.

The situation
I am updating products description for products using SQL and strings containing "\n" (I tried "\r\n" too) to properly format the contents...

e.g. UPDATE products_description SET products_description = 'Description : RING 18K\r\nColor : AMETHYST,RUBY\r\nGold Wt : 9.23g\r\nSemi Cts : 17.01cts\r\nCS 1 Pcs : 40\r\nCS 1 Type : RUBY\r\nCS 1 Cts : 0.66cts\r\nTotal WD Pcs : 129\r\nTotal WD Cts : 0.65cts\r\n' WHERE products_id = '7' LIMIT 1;

The output I expect is this
Description : RING 18K
Color : AMETHYST,RUBY
Gold Wt : 9.23g
Semi Cts : 17.01cts
CS 1 Pcs : 40
CS 1 Type : RUBY
CS 1 Cts : 0.66cts
Total WD Pcs : 129
Total WD Cts : 0.65cts

and that is the way it looks in MySQL (v3.23) and in the product edit page in Admin

However in the product display page it shows up like this:
Description : RING 18K Color : AMETHYST,RUBY Gold Wt : 9.23g Semi Cts : 17.01cts CS 1 Pcs : 40 CS 1 Type : RUBY CS 1 Cts : 0.66cts Total WD Pcs : 129 Total WD Cts : 0.65cts

completely ignoring my formatting!

What am i doing wrong...

You can check my page @
http://www.thunder-creation.com/zc_i...&products_id=7

[MichaelD]

Hi,

I found that putting <br> after each line worked for me but I wasn't using SQL to edit my product descriptions. I put the info in using the Zen Cart admin Edit Product page so it may not be the same in SQL but worth a try maybe.

BTW, your page took an age to load (on 2nd attempt) using Firefox 1.5.0.3.

[gjh42]

You can edit product descriptions in any way that works, but they are displayed as HTML output, not as db info. You need to use HTML tags to give whatever formatting you want.

[Vixay]

You can edit product descriptions in any way that works, but they are displayed as HTML output, not as db info. You need to use HTML tags to give whatever formatting you want.

Thanx a lot... that worked...

i am now using a table to format it correctly!

Sorry for th late reply... didn't look at this tab in firefor for weeks!.. .hehe :)