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
Bookmarks