Text formatting

Hi,
I could you tell me how you keep the text formatting when using mysql and php as when the page uses the data held in the database i lose all formatting such as paragraphs?

I dont follow, can you please provide more details.

hi sorry,
im trying to make a php news page. I have a page to allow me to upload the text to the mysql database however on the actual news page itself when it brings the text back from the database all the text has lost any paragraph spacing and other formatting such as bold or italic text which it originally had prior to going into the database. I hope that makes slightly more sense.

send a copy of the news insert page and a link where i can see the news article online to troubleshoot.

Hi Jason,
The input page is manage_news.php?
and the page it shows up on is legacy.php

If you see the test content i have put in i originally had paragraph spaces etc before it went into the database and when it came back out the text has no formatting.

In the insert record behavior, when selecting the binding for the text area, select the formatting option to convert new lines to BR tags. See the attached screen shot.

sorry jason how do you get to the insert record behaviour? do i take it this can be changed even though the pages are already made?

go to the server behaviors panel, and double click the insert record behavior to edit it.

thanks i have changed this but its still taking multiple spaces and paragraphs out

instead of using a textarea, use an HTML Editor field to give rich text editing capabilities.

replace the text area with an HTNL Editor filed.

webassist -> forms -> HTML Editor