Read rich text from MYSQL

[TheFenix]

I have a windows application which posts into a database and a PHP site that reads the database.

My problem is that when I display text blobs on the site all the rich text formatting is lost. Is it possible to display rich text formatting from mysql using PHP? If I can't do this then I would still like to settle on line breaks which I am currently not able to display either.

[rajavel]

tell me how the values from rich text is stored into the database table........

u need to use addslashes() and strip slashes() functions b4 storing the values and after getting the values from the database tables

[TheFenix]

Well the windows application which posts the original record was developed in delphi and uses the rich edit component. So the field value has all the necessary formatting for rich text but when I display it using php its just one big string of plain text.

[rajavel]

give me one sample data u r getting as a value in the table

and also give me one sample output file