php/mysql help

This site is best viewed in a modern browser with JavaScript enabled.

ianhaney

on my website I have products and in the product description I am getting \n\r showing after each line where as it should be hiding it for example see below

16 ml in each bottle\r\nLuxury Style Bottles\r\nAvailable in White, Clear, Peach, Purple, Red, Pink and Black

it should be like below

16 ml in each bottle
Luxury Style Bottles
Available in White, Clear, Peach, Purple, Red, Pink and Black

Any ideas as not sure if it is the php file or the database causing the issue

To see the issue go here - http://www.worldofcosmetics.co.uk/product_info.php?cPath=28&products_id=169

Thank you in advance

Ian

NogDog

Tough to tell without seeing any code. Might be aa symptom of "double escaping" data being inserted into the DB, often a result of having PHP's deprecated magic_quotes_gpc feature enabled, or you are setting values somewhere within your PHP code using single quotes when you need to use double quotes for those special escape sequences to work.